Database Reference
In-Depth Information
How it works...
The recipe shows you how to create a report using the dataset created by connecting to a
System Center Configuration Manager database data source. The steps demonstrate the
connections between the required prerequisites, data source creation, and dataset queries in
order to create the report.
The datasets are SQL queries that allow you to create the list of fields you use in your re-
ports. The layout of the report depends on the type you select and the grouping options you
plan to have. In the recipe example, the query (dataset) returns a list of computers and their
collection membership.
When the values field is used, it behaves like a standard flat table where all the selected
fields you use become column headings. The data is dynamically populated at the time the
report is run. The report is a definition of what you need to visualize.
The
Row
group field provides grouping and allows you to expand it to show the list of val-
ues for each row selection.
The Report Builder interface provides you with the formatting tools and wizards to trans-
form the data into your desired visual representation. This visualization and formatting is
similar to what you would perform in a word processor program; you can test out the vari-
ous formatting options by toggling between the run and design modes.
The final part of the recipe discuss how to save the report. Saved reports can be edited,
downloaded, and even saved with a different name to create a new version of an existing
report.
