Count the Number of Groups in Report

<< Click to Display Table of Contents >>

RayVentory Data Hub > 12.5 u5 > Dashboards and Reports Customization Guide > Designing Reports > Shape Report Data > Count Elements and Values 

Count the Number of Groups in Report

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

 

1.Insert the Group Header band, select the Group Fields section in the Actions category and add a new group field to group the report's data by the required field.
 
eurd-web-shaping-count-group-data
 

2.Switch to the Field List and drop the group field onto the created Group Header.
 
eurd-web-shaping-count-drop-filed-onto-group-header
 

3.Drop a label onto the Report Footer, expand the Summary section in the Actions category and set the Running property to Report.
 
eurd-web-shaping-group-count-summary-running
 

4.Click the Text property marker to invoke the menu. Select Text Expression to invoke the Expression Editor.
 
eurd-web-shaping-group-count-text-expression
 

5.In the Expression Editor select the sumDCount summary function in the Functions | Summary section:
 
sumDCount([CategoryName])
 
eurd-web-shaping-group-count-expression
 

6.Use the Text Format String property to format the summary's value.
 
eurd-web-shaping-group-count-format-string
 

7.Switch to Print Preview and see the group count in the report footer:
 
eurd-web-shaping-group-count-result