Count the Number of Records in a Report or Group

<< Click to Display Table of Contents >>

Raynet One Data Hub > 2025.4 > Dashboards and Reports Customization Guide > Designing Reports > Shape Report Data > Count Elements and Values 

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.Select the corresponding command in the Actions category and insert a Report Header or Footer to display the record count for the entire report.
 
eurd-web-shaping-insert-report-header
 

papercliper

Note:

Use a Group Header/Footer for displaying record counts for groups, and a Page Header/Footer for displaying record counts for pages.

 

2.Switch to the Field List panel and drop the corresponding data table field onto the created band to create a data-bound label.
 
eurd-web-shaping-drop-field-onto-report-header
 

3.Expand the Summary section in the Actions category and invoke the Running drop-down list. 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.
 
eurd-web-shaping-count-summary-running
 

4.Click the Expression property's ellipsis button. In the invoked Expression Editor, select the sumCount function in the Functions | Summary section.
 
eurd-web-shaping-count-expression
 

5.Use the Text Format String property to format the resulting value.
 
eurd-web-shaping-count-format-string
 

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

 

eurd-web-shaping-count-result