Home > Report Designer > The Basics > Change or Apply Data Grouping to a Report

Change or Apply Data Grouping to a Report

This document demonstrates how to group a report's data. Note that data grouping can be performed only if a report is bound to a table.

To group records in a report, do the following.

1. Create a new report. In this tutorial, we'll start with the following report.

   

2. Now, switch to the Group and Sort Panel , and click Add a Group. In the invoked list, choose a data member across which the report is to be grouped. Note that grouping across calculated fields is supported, as well.

   

   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.

3. After this, a Group Header band is added to the report, with the specified data member being set as its grouping criterion.

   Now, it's only left to drop the corresponding item from the Field List onto this band, so that it's displayed as a header for each group.

   

   If required, you also can apply mail merge to this label.

4. In addition, you can enable the corresponding Group Footer band, by checking the Show Footer option in the Group and Sort Panel.

   

   To manage the sorting order of the group's items (ascending or descending), use the Sort Order drop-down list.

5. Then, you can calculate a total across the group, by placing a Label onto this band, and specifying its Summary properties in the following way.

   

See also