Core components of SQL Server Reporting Services (SSRS)

Last Reply 6 months ago By dharmendr

Posted 6 months ago

Mention what are the core components of SSRS?

The core components of SSRS includes

  • A set of tool to View, Create and Manage report
  • A report server component that hosts and processes reports in a different formats like PDF, HTML, Excel, CSV,
  • An API, which enables developers to integrate with custom applications or to create custom tools to manage or build reports
You are viewing reply posted by: dharmendr 6 months ago.
Posted 6 months ago

Hi hudavercetin,

Core components of SSRS are as follows:

Report Server - It is the heart of SSRS which interacts with other components and plays key role in processing of data, deploying etc…

Report Server database - Two databases called reportserver and reportservertempdb which stores the reports definition data.

Report Designer - To create, modify and deploy the SSRS reports.

Report Builder - To create ad hoc reports. We can access report builder in report manager.

Report Manager - Web based application which allow us to view the data and manages the reports by interacting with Report server web service.

Data sources - Reporting services retrieves data from data sources like relational and multidimensional data sources.

Refer below link for more details.