1 of 1 people found this helpful
It sounds like you're searching for the attributes and then attempting to catagorize that information based up on machine ID. When querying its important to remember that you're querying for machines, not software or other attributes. When you create a query in the console you are telling the console to find you machines that have those attributes such as a specific software package or piece of hardware. This is the key howeve, always remember that the query will only find machines that fit the attributes that you define.
Go Tools | Reporting\Monitoring | Reports
Create a New Custom Report
Select the Query you wish to use
Right Click on DetailHeader and select Insert Group Header\Footer ( repeat for as many groups as you desire )
Right Click on GroupHeader1 and select Reorder Groups
When the window appears you should see a Step Structure with DH -> GH1 -> GHn.
Move the GroupHeader1 Above the DetailHeader in the structure
Select BOTH the DeviceName Label and Text Box out of DetailHeader and Detail and Cut them.
Paste them in GroupHeader1 and Click off to the Right to Deselect them
Click One time ontop of the Group and you should select (DeviceName) which is the Data Bound Field
Move this Field to the Right so they dont overlap
Select GroupHeader1 again and look at the properties Section on the Right hand Side
Under the Data Section, look for DataField
The DropdownList should contains a list of your Columns
Select DeviceName from the list
This Tells the GroupHeader to Group By this Field
Above the Data Section you should see the behavior Section
At the Bottom of the Behavior section before the Data Section Begins
Find 3 Attributes, RepeatStyle, KeepTogether, GroupKeepTogether
RepeatStyle - tells the GroupHeader to Repeat Every <value>, Select On Page
This way you get a New Header Section every page and improves the look
GroupKeepTogether - Select FirstDetail
GroupKeepTogether tells the group Header to create itself when repeating, only if its able to put data with it.
This way you dont get a Header at the Bottom of the Page and no data below it
KeepTogether - Select True
Repeat 9-17 for each GroupHeader
Click Preview and you should see your grouped Report
This process can be applied to any datafield that you wish to group by.