Creating reports with Report Builder
This recipe will walk you through the steps of using Report Builder 3.0 to create new reports for Service Manager. We will also show you how to create a custom folder structure in SQL Server Reporting Services to store your reports in.
Getting ready
Although Report Builder offers a visual wizard for creating the queries that will be used for retrieving data from the Service Manager Data Warehouse database, it is hardly possible to work with reporting effectively without at least knowing the basics of the Structured Query Language (SQL) used for querying relational databases.
Furthermore, you will need to get familiar with the database model of the DWDataMart database. The database model is well-documented and ...
Get Microsoft System Center 2012 Service Manager Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
