Count the Number of Records in a Report or a Group

Count the Number of Records in a Group

media_1449123589201.png

Set the Running option to Group and the Function to Count.

The Ignore NULL values option is useful for functions like Count or Average, because the number of elements counted will depend on it.

If required, you can specify the Format String (e.g. as Units Count: {0}). Note that value formatting is applied to a summary independently of the general formatting, and has a greater priority.

Count the Number of Records in a Report

media_1449123675971.png

To add a Report Footer band to your report, right-click anywhere on it, and in the invoked Context Menu, choose Insert Band | ReportFooter.

media_1449123707889.png

Then, place a Label bound to a data field onto it, and in the Property Grid, expand its Summary category.

Set the Running option to Report and Function to Count.

The Ignore NULL values option is useful for functions like Count or Average, because the number of elements counted will depend on it.

If required, you can specify the Format String (e.g. as Total Count: {0}). Note that value formatting is applied to a summary independently of the general formatting, and has a greater priority.

media_1449123766563.png