What is SSRS? Microsoft SQL Server Reporting Services shortly we are calling as SSRS, is a server-based reporting tool, by using SSRS we can able to create Charts, Maps, Spark line’s, tabular reports and Matrix reports from the Relational, XML, Excel, and Multidimensional sources
It is part of a suite of Microsoft SQL Server services, including SSAS and SSIS
Administered via a Web interface, it can be used to prepare and deliver a variety of interactive and printed reports
SSRS can generate reports in various formats, such as the web-oriented Hypertext Markup Language (HTML) and desktop application (Microsoft Excel and CSV) formats, thus allowing users to manipulate their data in whatever format is required.
Following are the Microsoft BI platform.
SQL Server: The traditional database engine, which also stores SSRS catalog data.
SQL Server Analysis Services (SSAS): A component for online analytical processing (OLAP) and data mining. OLAP performs data aggregation and allows users to traverse from aggregations to details looking through the dimensions (such as geography or time) of data. Data mining helps users to discover patterns in data.
SQL Server Integration Services (SSIS): A component for extracting, transforming, and loading (ETL) data.
SSRS provides three main tools from the user perspective
Report Viewer: It provides a very clean and neatly organized user interface for end users. Developers can also embed a Report Viewer control into both ASP.NET and Windows Forms applications.
Report Builder: The tool that provides users with a front end for ad hoc reporting against a SQL Server or Analysis Services database
Report Designer: The tool that takes on the job of building advanced reports. Although Report Builder does a good job as an ad hoc reporting tool, Report Designer was made to tackle really advanced reports.
Some SSRS features:
- Export to many formats, including HTML, PDF, XML, CSV, TIFF, Word reports (New in 2008), and Excel.
- Create ad hoc reports and save them to the server
- Embed graphics and images and external content
- Integrate with SharePoint
- Provide subscription-based reports and on-demand reports.
- URLbased report access
- Gauge and Chart controls to display KPI data