This article describes the architecture of SQL Server Reporting Services.
Architecture of SQL Server Reporting Services (SSRS)This article describes the architecture of SQL Server Reporting Services.SQL Server Reporting Services is a comprehensive reporting platform that includes processing components. Processing components are the basis for the multilayered architecture of SQL Server Reporting Services. Processing components interact with each other to retrieve data and deliver a report.SQL Server Reporting Services has the following two basic components.
Processors components are used to add a new functionality. It ensures the integrity of SQL Server Reporting Services.Extensions components are invoked by processors and do specific processing functionality.The following diagram shows the architecture of SQL Server Reporting Services. In this diagram the arrow lines show the data flow among components within and outside SQL Server Reporting Services.Architecture of SQL Server Reporting Services The following diagram shows the architecture of SQL Server Reporting Services.Tools and Components of SQL Server Reporting Services architectureThis architecture consists mainly of the following types of components and tools.
Report Builder
Report Designer
Report Manager
Report Server
Report server database
Data sources
Processing of SQL Server Reporting ServicesThis diagram shows the processing of SQL Server Reporting Services.On a report server, or a different server we choose, we will have access to the Report Manager website. The Report Manager website can be used to deploy and manage reports. End users run reports by the Report Manager and publish their reports if they have permission. An SQL Server Reporting Services is associated with a SQL Server instance. The SQL Server instance has two databases, the first is a report server and the second one is ReportServerTempdb. The end-user sends a HTTP request for a report. The report server finds the metadata of the report and sends a request for data to the data source then after the data is returned by the data source and merged with the report definition into a report. When the report is generated then it is sent to the client.SummaryThis article described the architecture of SQL Server Reporting Services and also describes every tool or component of the SQL Server Reporting Services architecture. This article also describes the processing of reporting services.
Reporting with Reports Viewer in Visual Studio 2005