SQL Reporting Service (SSRS) 2008 delivers several primary benefits:
- Report authoring - Report developers can create reports to be published using use Report Definition Language (RDL), an XML-based industry standard used to define reports.
- Report management - Report definitions, folders, and resources are published and managed as a Web service. New in SQL Server 2008 Reporting Services, administrators can use the Management Studio to organize reports and data sources, schedule report execution and delivery, and track reporting history.
- Themes and Skins - This allows for easy customization of a site's look-and-feel. You can define style information in a common location called a "theme" and apply that style information globally to pages or controls in a site.
- Report delivery - SQL Server Reporting Services supports both on-demand (pull) and event-based (push) delivery of reports. SQL Server Reporting Services can be used to create end user reports in several different formats including HTML, PDF, and Excel.
- Report security - SQL Server Reporting Services implements a flexible, role-based security model to protect reports and reporting resources.