Count the Number of Groups in a Report

  • 2 minutes to read

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


You can use this approach to counting groups when the UserDesignerOptions.DataBindingMode is set to DataBindingMode.Expressions or DataBindingMode.ExpressionsAdvanced.

See Count the Number of Groups in a Report to learn about the legacy approach to solving this task.

See Data Binding Modes to learn more about the available binding modes.

A report can display the total number of groups after binding your report to data and providing content to the report's detail band.

  • First, group the report's data. Switch to the Group and Sort panel and create a new group. Enable the Show Header option to display the group header in the report.


  • Switch to the Field List and drop the group field onto the created group header.


  • Right-click the report's surface and add a report footer to the report.


  • Drop a label onto the report footer and click its smart tag. In the invoked Label Tasks window, click the Summary property's ellipsis button.


  • In the Summary Editor window:

    • Set the Summary running property to the Report value.
    • Set the Summary function property to DCount.
    • Set the Argument expression property to [CategoryName].


  • Back in the Label Tasks window, you can use the FormatString property to format the summary's value:


You can see the group count in the report footer when switching to Print Preview: