Change or Apply Data Grouping to a Report

Reporting User Guide

Report Editing Basics : Change or Apply Data Grouping to a Report

Data grouping can be performed only if a report is bound to a data source.

To group records in a report, follow these instructions.

•

Add a Group Header band to the report.

Right-click anywhere on the report, and in the displayed Context Menu, point to Insert Band and click GroupHeader.

•

The Field List is then displayed. Drop a field, which will be used as the grouping criteria, from the Field List onto the GroupHeader band.

•

Drop a field, representing the report’s general data onto the report's Detail band.

•

Click the Smart Tag of the GroupHeader band, and in the displayed actions list, click the ellipsis in the Group Fields section. The GroupField Collection Editor window is displayed.

•

In this window, click Add to add a new grouping field, and set its Field Name property to the required field.

Note:

To define whether the sort order for this grouping field should be ascending or descending, use the Sort Order property.

•

To apply the settings and close the window, click OK.

•

Click the GroupHeader band's Smart Tag again, and in the Group Union dropdown menu, select Whole Page, so that a report group starts on a new page if it does not fit entirely on the previous one.

The grouping is now applied to the Report. Switch to the Preview tab to view the result.