Groups allow you to create detailed data rows. For example, if you have a table that lists the suppliers for a national restaurant chain, you can group the suppliers by the State field. The suppliers’ names are then rearranged so that all suppliers located in Main, for instance, are located under a “Maine” header row; suppliers in Maryland are together under a “Maryland” header row, and so on.
You can use multiple fields to make more specific nested groups.
By adding a group based on the City field to the table described above, the restaurant suppliers are arranged by City within the State groups.
It is important to note that only fields can be applied to a table as a group; measures cannot.
Data is grouped in the table according to the order defined. You can change the order by dragging the groups into position, if needed.
Creating a Group
In the Data Source Selection panel, click to select the field you want to add to the table as a group.
Drag the field to the Groups box in the Layout Band. The reports view refreshes and displays the data grouped under a new header row.
Note: You may also add a group to the table by right-clicking a field and selecting Add as Group.
Removing a Group
In the Layout Band, click the X next to the field’s name in the Groups box.
Moving the Grouping Order Up or Down
In the Layout Band, drag the name of the group you want to move into its new position.
Hiding Group Members
Once the report is created and saved, use the legends below the chart to hide or show group members.
To hide a group member, click on the member name in the legend below the chart. The member is removed from the chart and the legend is grayed out.
To unhide a group member that has been hidden, click on the grayed-out legend for the member.