Change or Apply Data Grouping to a Report

Add a Group Header band to the report. For this, right-click anywhere over the report's surface, and in the invoked Context Menu, point to Insert Band and click GroupHeader.

Click the Add Group button.

Select the field that you want to group.

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

Click the Smart Tag of the GroupHeader1 band, and in the invoked actions list, click the ellipsis button in the Group Fields section. The GroupField Collection Editor dialog will appear.

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

Also, you can define whether the sort order for this grouping field should be ascending or descending, by using the Sort Order property.

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

Again, click the GroupHeader1 band's Smart Tag, and in the Group Union drop-down list, select Whole Page, so that a report group starts on a new page if it doesn't fit entirely on the previous one.

The report is now ready. Switch to the Preview Tab, and view the result.