Unpacking System Center Report Building Tools - Microsoft System Center Reporting - page 110

11. In the Relationships section, click on Add Relationship , as indicated in the fol-
lowing screenshot:
12. Select V_GS_SYSTEM as Left Table and V_GS_OPERATING_SYSTEM as
Right Table . Double-click on the space under Join Fields . Click on the Add
Field button in Edit Related Fields . Select ResourceID under Left Join Field
and ResourceID again under Right Join Field . Click on OK , as shown in the
following screenshot:
13. Click on OK twice. This completes the dataset creation.
Creating a basic report
Use the following steps to create a basic report; this report uses the data source and data-
set created in this chapter:
1. Ensure that the Insert tab is selected. Under Data Regions , click on Table . Then,
click on Table Wizard… . Select Choose an existing dataset in this report or a
shared dataset . Ensure that the dataset you created is selected and then click on
Next .
2. On the Arrange fields page under Available Fields , select and drag Name0 and
Caption0 to the Values box in the lower-right pane of the New Table of Matrix
page and click on Next .
3. Click on Next on the Layout page. Select Generic on the Choose style page and
then click on Finish .
4. Click on the Click to add title space and type SCCM computers with OS .