SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Understanding and Installing Reporting Services

SQL Server Reporting Services (SSRS) is used to centrally create, manage, and distribute the reports needed within your organization. Many companies install a dedicated SQL Server just for SSRS, and others include SSRS as part of another database server installation. As long as the performance is acceptable, both methods will work well. SSRS solves the problem of reporting without requiring third-party components; however, SSRS is not as mature as third-party products such as Crystal Reports, so the DBA should consider his options carefully.

SSRS provides support for several types of reporting solutions including:

Ad Hoc Reporting In many organizations or departments within organizations, users ...