The architecture of SQL SERVER Reporting SERVICES (SSRS) consists of the FOLLOWING components:-

• Report Builder: It's a client-side ad-hoc report publishing tool that runs on the user's computer. It has an easy-to-use drag-and-drop interface.
• Report Designer: The Report Designer tool aids in the creation of a variety of reports. It's a publishing tool for Visual Studio or Business Intelligence Development Studio (BIDS).
• Report Manager: Report Manager is a web-based tool that comes with Reporting Services and is responsible for all areas of report management.
• Report Server: It is a server that stores metadata information using the SQL Server database engine.
• Report Server Database: It keeps TRACK of metadata, report definitions, resources, security settings, and delivery information, among other things.
• Data Sources: Data is retrieved from data sources such as relational and multidimensional data sources via reporting services.

Working of SQL Server Reporting Services: Any data source, such as Oracle, MySQL, SQL Server, and so on, can be used. Any of these data sources can be linked to Microsoft SQL Server. The data retrieval and rendering processes begin after the data sources are connected to the SQL Server. The process of filtering and evaluating data in order to meet the requirements is known as rendering. Processing of reports: Rendering is followed by report processing. The process of publishing, filtering, and amending EXISTING reports is known as report processing. Web service interfaces in XML: When you publish a report, it is automatically published to the website via the XML web service interface. SQL Server includes security, scheduling, and delivery.