Introduction to SQL Server Reporting Services (SSRS)
What Is SSRS?
SSRS is one of the components in the Microsoft Business Intelligence (BI) platform. Its mainly for reporting purpose at business level. It provides a unified, server-based, extensible, and scalable platform from which to deliver and present information. It supports web-based delivery and interactive content.
SSRS is capable of generating reports in various formats, such as the web-oriented Hypertext Markup Language (HTML) and Microsoft Excel and CSV), PDF formats. We can deploy the SSRS reports in Team Foundation Server as Work Items. In addition, SharePoint can be used as a front end for SSRS, allowing reports to be presented directly in portals.
Here is the list of SSRS features:
- Retrieve data from managed providers, OLE DB, and ODBC connections
- Display data in a variety of ways, including tabular, free form, and charts
- Export to many formats such as HTML, PDF, XML, CSV, TIFF, Word reports (New in 2008), and Excel
- Aggregate and summarize data (grouping)
- Add in report navigation
- Embed graphics and images and external content
- Integrate with SharePoint
- URL-based report access
- Provide subscription-based reports and on-demand reports
Another nice feature of SSRS is its extensibility. Because there is no way that the developers of SSRS could have anticipated every need of an enterprise reporting solution, they made SSRS extensible. This extensibility enables developers to use SSRS in any number of ways, from embedded reports to customized reporting solutions.
The default configured databases in SQL Instances are: ReportServer, ReportServer TempDB
The default configured databases in SQL Instances are: ReportServer, ReportServer TempDB
Pre-check: make sure that reporting services are started
Configuring SSRS:
Go to Microsoft SQL Server in all programs and Click on Reporting Service under Configuration Tools folder.Reporting Service Configuration manager |
Step 1: Click on Reporting Services Connect to Report Server Instance
Click on Connect and Find the Report Server Status:
Proved the Service Account details to run the Report Services:
Report Server Web URL: we can access Report Server Instance through web interface
Report Server Databases:
Report Manager URL: We can access the reports through web interface
Email Settings:
Encryption backup & restore keys:
No comments:
Post a Comment