Microsoft SQL Server Reporting Services
Microsoft SQL Server Reporting Services or SSRS is a server-based report generating software system which is a part of the Microsoft business intelligence framework. This framework also includes SQL Server Analysis Services (SSAS) and SQL Server Integration Services (SSIS). Microsoft Business Intelligence Framework is used for enterprise data analysis to deliver real-time information to support daily operations and help drive decisions.
SSRS is a scalable and extensible platform that is administered via Web-interface and is used to design, develop, test, and deploy all kinds of reports from traditional printed reports to web-based and interactive reports. Users can configure SSRS to deliver reports to file shares and inboxes. Reports can be downloaded in various formats such as Excel, CSV, PDF, XML, TIFF, HTML and Doc. Microsoft SQL SSRS allows users to manipulate their data in any format they need. Besides, when using SharePoint as a front end for SSRS, reports can be presented directly in corporate portals. Users can SSRS directly or instead use a web-based application – Report Manager that provides a well-organized interface for end users.
Microsoft SQL SSRS covers needs of multiple information users divided by Microsoft into three categories: analysts, information explorers, and information consumers. To address different needs of reporting users, Microsoft SQL SSRS has three essential tools:
- Report Viewer which is a tool for viewing reports over the Web from Report Manager. A Report Viewer control can be also embedded by developers into Windows Forms and ASP.NET applications.
- Report Builder which is an ad hoc reporting tool that does not require users to have extensive knowledge of SQL to create reports.
- Report Designer which is a tool that is used for building advanced reports.
SSRS has a wide variety of features to meet complex business reporting needs. Data can be retrieved from SQL Server, Analysis Services, Oracle, Essbase, Access and many other databases and be displayed in plenty of ways such as free form, tabular, and charts.