Change or apply data grouping to a report
This procedure demonstrates how to group a report's data.
Data grouping can only be performed if a report is bound to a data source.
-
Add a Group Header band to the report.
To do this, right-click anywhere over the report's surface, and click.
For more information, see Report bands.
This creates the GroupHeader1 band. -
In the Field List, click and drag the field you want to use as a grouping criteria onto the GroupHeader1 band.
-
Drag another field to represent the general report's data onto the report's Detail band.
-
Click the Smart tag of the GroupHeader1 band, and in the actions list
click the browse button (...) in the Group Fields section.
This opens the GroupField Collection Editor dialog box.
-
Click Add to add a new grouping field, and then set its Field Name property to
the required field.
You can set the Sort Order property to define the sort order for this grouping field as ascending or descending.
- Click OK to apply the changes and close the GroupField Collection Editor dialog box.
-
Click the GroupHeader1
band's Smart Tag, and in the Group Union drop-down list, click Whole Page.
This causes a report group to start on a new page if it does not fit entirely on a page.
- Switch to the Preview Tab to view the result.