SQL Server Reporting Services(SSRS) is a solution that customers deploy on their own premises for creating, publishing, and managing reports, then delivering them to the right users in different ways, whether that’s viewing them in web browser, on their mobile device, or as an email in their in-box.
How does SSRS work?
Below is the reporting life cycle follow by most professionals while working with SSRS:
Authoring: The report author defines the report layout and sources of data in this phase. Reports syntax is Report Definition Language (RDL is a XML based industry standard for defining reports).
The report authoring tools included in this phase are:
- SQL Server Business Intelligence Development Studio
- Report Builder 1.0 and Report Builder 2.0
Management: This phase involves managing the published reports as a part of the web-service.
- Use of Report Manager web interface
- Role Base security model based on Windows Authentication
- Control over “Execution” (When reports get their data)
Delivery: Reports can be delivered to the consumers either on their demand or based on an event.
- Web based delivery via Report Manager web site
- Subscriptions allow for automated report delivery
- URL Access, Web Services and Report Viewer control
To understand more about SSRS with an example, check out this video on SSRS :
BI Developer specialized in SQL Query Development/ SSIS/ SSAS/ SSRS /Power BI/ MS Office. Enjoy working in data analysis and presentation, challenging projects where I can uncover valuable business insights for an organization from previously under-utilized data sources and creating custom made reports and interactive dashboards
