Group Report Data

Groups report data using a GroupHeader band with a defined field item which is used as the grouping criteria.

Note:
Data grouping can only be performed if a report is bound to a data source.

1. Right-click anywhere on the report, select Insert Band and GroupHeader from the drop-down menus.

   

2. On the Field List window, click the Field List tab and select the required field item to be used as the grouping criteria.

   

3. Drag and drop the selected field item onto the GroupHeader area of the report. A control is created which displays the name of the field item and the yellow database icon.

   

4. On the Field List window, click the Field List tab and select the required field item to be used as the report general data.

   

5. Drag and drop the selected field item onto the Detail area of the report. A control is created which displays the name of the field item and the yellow database icon.

   

6. Click the Smart tag symbol at the top of the GroupHeader band to display the Tasks window.

   

7. Click the ellipsis next to Group Fields to display the GroupField Collection Editor window.

   

8. Click Add to add a new entry.

9. Set the Field Name property to the required field.

10. Set the Sort Order property (ascending or descending).

11. Click OK to apply the settings and close the Group Field Collection Editor window.

12. Click the Smart tag symbol at the top of the GroupHeader band to display the Tasks window.

13. Click the ellipsis next to Group Union and select Whole Page from the drop-down list to start a report group on a new page if it does not fit entirely on the previous page.

14. Click the Print Preview tab to display a preview of the current report layout with the grouped report data.