Reporting Services Architecture

Visual C# Tutorials

Database Tutorials

Reporting Services Architecture Report Server Web and Windows Service Programmatic Interfaces Report Processor Command-Line Utilities Reporting Services Exts. Report Server Databases Scheduling and Delivery Report Builder - 2005 Report Model Designer - 2005 Report Designer Report Manager SSMS - 2005 RSCT - 2005 RSPrintClient - 2005 Performance Monitoring Summary WMI Provider

This Book Reviewed!

© 2006 Sams Publishing

This tutorial—Reporting Services Architecture—is from Microsoft SQL Server 2005 Reporting Services, by Michael Lisin, Jim Joseph. Copyright © 2006 Sams Publishing. All rights reserved. This article is reproduced by permission. This tutorial has been edited especially for C# Online.NET.  Read the book review!

SQL Server Reporting Services (SSRS) is a comprehensive and extensible reporting platform, which includes an integrated set of processing components, programmatic interfaces, and tools. This chapter discusses the SQL Server Reporting Services (SSRS) architecture in detail.

Reporting Services Architecture in SQL Server 2005

SSRS is a comprehensive and extensible reporting platform, which includes an integrated set of processing components, programmatic interfaces, and tools. Processing components are the basis for the multilayered architecture of SSRS and interact with each other to retrieve data, process layout, render, and deliver a report to a target destination. SSRS supports two categories of components:

Processors— Ensure integrity of SSRS and supply an infrastructure that enables developers to add a new functionality (extensions). Processors itself are not extendable in this release of SSRS.

Extensions— Assemblies that are invoked by processors and perform specific processing functionality, such as data retrieval. Developers can write custom extensions.

Reporting Services architecture diagram is depicted in Figure 3.1; components are described in more details later in this chapter. Arrows on the diagram show a data flow between components "within" and "outside" of SSRS (external tools, applications, services, and utilities).

Figure 3.1 Report ServerReporting ServicesReport ServerReporting Services architecture.