Architecture Of SSRS And Components

SSRS 

Working : 

1. The report users are the peoples who work with the data as well as want some insights from data. They send a request to the SSRS server

2. SSRS server finds the metadata of the report and sends a request for data to the data sources.

3. Data returned by the data source is merged with the report definition into a report.

4. When the report is generated, it is returned to the client.

 

 

 

 

 

Architecture : 

report services architecture includes development tools, administration tools, and report viewers

Components :

Report Builder : 

It is an ad_hoc Report Publishing Tool used to publish the reports into a server and is easy to use.

Report Designer :

The Report designer tool helps to develop all types of reports. It is a publishing tool that is hosted in Visual Studio or Business Intelligence Development Studio (BIDS).

Report Manager

The report managers check the report, matching it with the given requirements. They make decisions based on those reports.

Report Server :

It is a server which uses the SQL Server database engine to store metadata information

Report server database :

It stores metadata, report definitions, resources, security settings, delivery data, etc.

Data sources :

Reporting services retrieve data from data sources like relational and multidimensional data sources.