Count the Number of Groups in a Report

This document describes how to count the number of groups in a report.

1. Insert the Group Header band, select the Group Fields section in the Group Header Tasks category and add a new group field to group the report's data by the required field.

   

2. Switch to the Field List and drop the group field onto the created Group Header.

   

3. Drop a label onto the Report Footer, expand the Summary section in the Label Tasks category and set the Running property to Report.

   

4. Click the Text property marker to invoke the menu. Select Text Expression to invoke the Expression Editor.

   

5. In the Expression Editor select the sumDCount summary function in the Functions | Summary section:

   sumDCount([CategoryName])

   

6. Use the Text Format String property to format the summary's value.

   

7. Switch to Print Preview and see the group count in the report footer: