Use groups to organize data in a table. There are several ways to do this, and you can use detail grouping to organize data as well.
To group a table
- In the Layout view of the report, right-click the UI on the left side of the table and choose Insert Group.
- Type a Name for the group.
- Under Group on, type or use the Expression Editor to create an expression by which to group the data.
- Under Document map label, you can optionally set a label to add the item to the document map (table of contents).
- Under Parent group, you can optionally set the parent group for a recursive hierarchy. See Grouping and Sorting Data for more information.
- You can also select the following options on this page:
- Page break at start
- Page break at end
- Include group header
- Include group footer
- Repeat group header (on each new page)
- Repeat group footer
To group a table's details
- In the Layout view of the report, select the detail row and right-click in the UI on the left side of the table and choose Edit Group.
- Type a Name for the group.
- Under Group on, type or use the Expression Editor to create an expression by which to group the data.
- Under Document map label, you can optionally set a label to add the item to the document map (table of contents).
- Under Parent group, you can optionally set the parent group for a recursive hierarchy. See Grouping and Sorting Data for more information.
- You can also select the Page break at start and Page break at end options on this page.