What are SQL Server Reporting Services
SQL Server 2005 Reporting Services (SSRS) delivers enterprise, Web-enabled reporting functionality so you can
create reports that draw content from a variety of data sources, publish reports in various formats, and centrally manage
security and subscriptions.
SQL Server 2005 Reporting Services is a server-based reporting platform that you can use to create and manage tabular,
matrix, graphical, and free-form reports that contain data from relational and multidimensional data sources. The reports
that you create can be viewed and managed over a World Wide Web-based connection. SQL Server Reporting Services includes
the following core components:
- A complete set of tools that you can use to create, manage, and view reports.
- A Report Server component that hosts and processes reports in a variety of formats. Output formats include
HTML, PDF, TIFF, Excel, CSV, and more.
- An API that allows developers to integrate or extend data and report processing in custom applications, or
create custom tools to build and manage reports.
The reports that you build can be based on relational or multidimensional data from SQL Server, Analysis Services,
Oracle, or any Microsoft .NET data provider such as ODBC or OLE DB. You can create tabular, matrix, and free-form
reports. You can also create ad hoc reports that use predefined models and data sources.
The reports that you build in SQL Server Reporting Services surpass traditional reporting both visually and functionally
by including interactive and Web-based features such as drill-down reports that enable navigation through layers of data,
parameterized reports that support content filtering at run time, free-form reports that support content in vertical,
nested, and side-by-side layouts, links to Web-based content or resources, and secure, centralized access to reports over
remote or local Web connections.
The development and run-time architecture of SQL Server Reporting Services was purposely created in a modular design
to support third-party extension and integration opportunities. SQL Server Reporting Services integrates with other
Microsoft technologies out-of-the-box.
Click here to go back to the SQL Server content index page.
|