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.

1. Add a Group Header band to the report.

2. 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.

3. Drop a field, which will be used as the grouping criteria, from the Field List onto the GroupHeader band.

   

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

   

5. 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.

   

6. 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.

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

8. 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.

9. Switch to the Preview tab to view the result.