Skip to main content
A newer version of this page is available. .

Count the Number of Records in a Report or Group

This document describes how to display the number or records in a report or group.

  • Right-click the report’s design surface and add a report header or footer to display the record count for the entire report.



    Use a group header/footer for displaying record counts for groups, and a page header/footer for displaying record counts for pages.

  • Switch to the Field List and drop the corresponding data table field onto the created band to create a data-bound label:


  • Click the label’s smart tag. In the invoked Label Tasks window, click the Summary field’s ellipsis button.


  • In the Summary Editor window:

    • Set the Summary property. Select Report to count the records throughout the entire report, or select Group or Page to reset the record count for every group or page.
    • Set the Summary function property to DCount.
    • Set the Argument Expression property to [ProductName].


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


You can switch to Print Preview to see the resulting report: