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

1. In the Group and Sort Panel, click Add a Group.

2. From the list, choose the data which will be used to group the report. Note that grouping across calculated fields is supported as well.

   

3. Specify the sort order and make sure Show Header is checked.

4. If multiple groups are created, you can specify the priority for each group, by selecting it in the Group and Sort Panel, and using the Move Up and Move Down buttons.

   A GroupHeader band is then added to the report.

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

   

6. Drop a field, representing the report’s general data onto the report's reportDetail band.

   

7. Add a corresponding GroupFooter band by checking the Show Footer option in the Group and Sort Panel.

8. A calculated total for each group may be set to be displayed in the GroupFooter band by placing a label onto the band, and specifying its Summary properties. For example:

   

   The grouping is now applied to the Report.

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