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.
1.Right-click the report's design surface and add a Report Header or Footer to display the record count for the entire report.
2.Switch to the Field List and drop the corresponding data table field onto the created band to create a data-bound label.
3.Click the label's smart tag. In the invoked Label Tasks window, click the Summary field's ellipsis button.
4.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.
5.Back in the Label Tasks window, you can use the Format String property to format the resulting value:
You can switch to Print Preview to see the resulting report.
