SQL Server 2005 Reporting Services lets you create, manage, and deliver a variety of report types that contain data from relational and multidimensional data sources as well as any data source that has a .NET Framework managed data provider, an OLE DB data provider, or an ODBC provider.
You can create tabular, matrix, chart, and free-form report layouts. Graphical elements can be incorporated into the reports and the reports can be nested to provide drill down functionality. Document maps and bookmarks can be added to facilitate navigation in large or complex reports.
Reporting Services export formats include HTML, MHTML, PDF, Excel, XML, CSV, and image (TIFF).
You can deliver reports using a URL, using the report viewer control in either a Windows or Web application, or through a Web service. Report delivery options include: on-demand, through SharePoint sites including SharePoint Web parts, automated reports, subscription reports, and automated reports based on data.
Reporting Services has two report authoring tools:
Reporting Services is an open and extensible reporting platform. The API lets you deploy, install, and manage Reporting Services components to support custom data, delivery, rendering, and management requirements. Reporting Services includes configuration, monitoring, and management tools.
This book introduces the most important aspects of Reporting Services. You will learn how to design, define, deploy, deliver, and manage reports.