[Rob Stack from our UA team has provided today’s post]
SQL Reporting Services in Configuration Manager 2007 R2 offers a number of advantages over traditional Configuration Manager reporting methods. One of the major advantages of this new feature gives users who may have little knowledge of SQL Server the ability to easily create reports using SQL Server Report Builder. Report builder allows the report author to drag and drop view items from the database to easily create ad-hoc reports. However, before the report author can create reports, you must define the views and objects within these views which will be presented. The items that will be presented to the report author are stored in a report model.
In this post, you’ll discover how to create new SQL report models to enable report authors to create reports. The post covers only one possible scenario and you are encouraged to experiment with your own scenarios. Report Builder contains many more features than those listed in the post, such as the ability to create graphs and charts.
Creating a report model is a fairly lengthy procedure that is too long to be presented as a blog post, so you will find the tutorial attached to this post as a Word document. Please click the AuthoringReportModelsForCM2007R2.docx attachments link below to read the remainder of this post and feel free to post any comments or suggestions.
This posting is provided “AS IS” with no warranties, and confers no rights.