Overview of SQL Reporting Services
Updated: February 1, 2009
Applies To: System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3
SQL Reporting Services in Configuration Manager 2007 R2 enables administrators to use the advanced reporting features of Microsoft SQL Server Reporting Services from the Configuration Manager console. Advantages of using this solution include the following:
|The information in this topic applies only to Configuration Manager 2007 R2 and Configuration Manager 2007 R3.|
Uses an industry standard reporting system to query the Configuration Manager 2007 database.
SQL Reporting Services offers higher performance, availability and scalability over existing reporting in Configuration Manager 2007.
Enables users who are not familiar with Configuration Manager 2007 reporting to generate ad hoc reports.
Enables users to subscribe to reports; for example, a manager could automatically be e-mailed a report each day, detailing the status of a software update rollout.
Simplifies the creation of SQL-based reports in Configuration Manager 2007 R2.
Enables users to export reports in a variety of popular formats.
Reports can be created in SQL Reporting Services using a number of methods, including the following:
By importing existing Configuration Manager 2007 reports into SQL Reporting Services using the Copy Reports to Reporting Services Wizard.
By creating new reports using the Create Report Wizard.
By using Microsoft Report Builder, supplied with SQL Server.
|Using SQL Reporting Services on your site does not replace the existing Configuration Manager 2007 reports.|
For more information about installing and configuring SQL Reporting Services, visit the SQL Reporting Services Web site at http://go.microsoft.com/fwlink/?LinkId=111840.
In This Section
- Administrator Checklist for SQL Reporting Services
- Provides a checklist for a recommended path to installing, configuring, and using SQL Reporting Services in Configuration Manager 2007 R2.
- About Using Microsoft Report Builder to Create Reports in SQL Reporting Services
- Describes the features of Microsoft Report Builder and provides information on how it can be used to create reports.
- About Report Models in SQL Reporting Services
- Provides information about how report models are used in SQL Reporting Services to display only relevant information to the administrator building a report.
- About Report Folders in SQL Reporting Services
- Provides information about using report folders in SQL Reporting Services.
- About Security in SQL Reporting Services
- Provides information about report security in SQL Reporting Services.
ConceptsAdministrator Checklist for SQL Reporting Services
Planning for SQL Reporting Services
Prerequisites for SQL Reporting Services
Other ResourcesConfiguring SQL Reporting Services
SQL Reporting Services in Configuration Manager 2007 R2 and Later
Tasks for SQL Reporting Services
Technical Reference for SQL Reporting Services
Troubleshooting SQL Reporting Services
For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.