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.

• 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

See Also