Core components of SQL Server Reporting Services (SSRS)

on Dec 20, 2020 10:33 PM

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
Download FREE API for Word, Excel and PDF in ASP.Net: Download
on Dec 20, 2020 10:42 PM

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.