Reporting Services (or SQL Server Reporting Services - SSRS) is a service available as part of the Microsoft SQL Server package that allows you to create, manage and deliver various types of reports. Here are the main features and functions Reporting Services:
- It allows you to create a variety of reports such as tabular reports, charts, graphs, map reports, as well as subscription reports and interactive reports.
- Ability to connect to various data sources, such as databases, Excel files, text files or external data sources.
- It has a graphical environment (Report Builder and SQL Server Data Tools) that facilitates the design and creation of reports without the need for programming.
- Allows you to manage reports, catalog, share, schedule and view reports.
- Provides various report delivery methods, including email, server sharing, interactive web publishing, printing, etc.
- It has permission management mechanisms that enable control of access to reports.
- Enables the creation of reports that allow users to interactively filter, sort and navigate data.
SQL Server Reporting Services is a tool used by organizations to generate, manage and deliver various types of business reports. Thanks to this tool, users are able to effectively use data, visualize information and support decision-making based on data analysis.
- Introduction to Reporting Services
- Creating reports
- Shared sources
- Using grouping in reports
- Parameterization of reports - use of filters and parameters
- Report Manager - publication, properties, security management
- Report Manager - cache and subscription usage
- Self-Service BI and PowerView reports