SSRS was first introduced as an add-on for SQL Server 2000, but in SQL Server 2005, it was published as the main component of the SQL Server RTM release. SSRS as a Reporting Service provides web-based reports with charts, grouping, ordering, filtering, and many other features. From SSRS 2005 to the date of writing this book, SSRS improved a lot in terms of features and functionalities.

In the architecture diagram that follows, there are three main components highlighted: SSRS Databases, SSRS Web Applications, and the SSRS Report object itself. Reporting Services installs itself as a part of the Microsoft SQL Server setup media. There are two built-in databases for SSRS: ReportServer DB and ReportServer TempDB. ReportServer DB stores the report definition, snapshot, execution log, and some other information. ReportServer TempDB stores the session and cached information. The following diagram shows the architecture diagram of Reporting Services:

The SSRS Report...