Add Grouping Levels

Purpose

This page is used to group data in a report. For instance, in the case of a report displaying car sales information, records corresponding to the same model may need to be kept together. Each set of records with the same model will become a 'group' with its own header.

Nested grouping and grouping against multiple fields are fully supported.

If grouping is not required, click Next to skip this step.

Page Interface

The list on the left-hand side displays data fields that can be used to group data. To apply grouping, use one of the following methods:

• Select columns and click right arrow (>).

• Drag required columns to the box on the right-hand side.

• Double-click columns.

  Note:
  Grouping fields on the right-hand side can be selected by clicking them. This is useful if they need to be removed or their order changed. To accomplish the latter, use the up arrow () and down arrow () buttons.

Result

To stop the wizard at this step click Finish. In this case, the report will look similar to the image below:

To customize the report further, click Next. If data grouping has been applied on this page, the next step displayed will be Summary Options. If not, the Summaries step will be skipped and the next step will be Choose Report Layout.