Report Studio

Grouping Data

Group data items in a list report to remove duplicate values. For example, you have a report that shows products purchased. For each product, the product type is also shown. You group the Product type column to show only one instance of each product type in the list.

You can also group data items in repeaters and in page sets.

In addition to grouping, you can specify the sort order of data items. In lists, you can sort data items within groups as well as ungrouped items. In crosstabs, you can sort row and column items. For more information, see Perform Advanced Sorting.

To Group a data Column:

Click the column you want to group on.

You can click either the column heading or one of the column cells.

Tip: To perform multiple groupings at once, use Ctrl+click or Shift+click.
From the Structure menu, click Group/Ungroup .

A symbol appears indicating that the column is grouped. You can control when its values appear by setting the group span,and the column appears in the list of headers and footers that you can add to the report. See Add a Header or Footer.