With the R2 release of System Center Configuration Manager 2007, the product now supports the use of SQL Reporting Services as a reporting solution. This is the direction for reporting going forward and it offers a good number of exciting possibilities for building great custom reports. In the January edition of TechNet magazine, our very own Steve Rachui published an article discussing this feature and showing a sample method for building custom reports:
Reporting is a crucial ability for most organizations—and the ability to provide robust reporting of various Microsoft System Center Configuration Manager (SCCM) functions is no exception. Reporting is a feature that hasn’t changed much over several versions of Systems Management Server and SCCM. With the release of SCCM R2, reporting has undergone one significant change—the ability to interface and take advantage of SQL Server Reporting Services (SSRS). This one change brings with it the ability to make use of the many robust features SSRS provides. Like any new technology, there is a learning curve associated with SSRS—but the benefits are well worth it. This article will discuss the integration between SCCM and SSRS and walk through a very simple example of building a report in SSRS and publishing for use in SCCM.
To continue reading see http://technet.microsoft.com/en-us/magazine/ee914611.aspx
J.C. Hornbeck | System Center Knowledge Engineer