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.