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.
  1. Add a Group Header band to the report.
    To do this, right-click anywhere over the report's surface, and click Insert Band > GroupHeader.

    For more information, see Report bands.

    This creates the GroupHeader1 band.
  2. In the Field List, click and drag the field you want to use as a grouping criteria onto the GroupHeader1 band.
    Group Data
  3. Drag another field to represent the general report's data onto the report's Detail band.
    Group Data
  4. Click the Smart tag of the GroupHeader1 band, and in the actions list click the browse button (...) in the Group Fields section.
    Group Data
    This opens the GroupField Collection Editor dialog box.
  5. 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.
  6. Click OK to apply the changes and close the GroupField Collection Editor dialog box.
  7. Click the GroupHeader1 band's Smart Tag, and in the Group Union drop-down list, click Whole Page.
    Group Data
    This causes a report group to start on a new page if it does not fit entirely on a page.
  8. Switch to the Preview Tab to view the result.