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 ...
Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.