Topic Last Updated—August 2008
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:
 Note |
|---|
| 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.
| Note |
|---|
| 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.
See Also
Concepts
Administrator Checklist for SQL Reporting ServicesPlanning for SQL Reporting Services
Prerequisites for SQL Reporting Services
Other Resources
Configuring SQL Reporting ServicesSQL Reporting Services in Configuration Manager 2007 R2 and Later
Tasks for SQL Reporting Services
Technical Reference for SQL Reporting Services
Troubleshooting SQL Reporting Services