<< Click to Display Table of Contents >>

 

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

1.Switch to the Group and Sort panel and create a new group. Enable the Show Header option to display the Group Header in the report.

eurd-win-shaping-count-group-data

2.Switch to the Field List and drop the group field onto the created Group Header.

eurd-win-shaping-count-drop-filed-onto-group-header

3.Right-click the report's surface and add a Report Footer to the report.

eurd-win-shaping-insert-report-footer

4.Drop a label onto the Report Footer and click its smart tag. In the invoked Label Tasks window, click the Summary property's ellipsis button.

eurd-win-shaping-group-count-summary-running

5.In the Summary Editor window:

oSet the Summary running property to the Report value.

oSet the Summary function property to Count (Distinct).

oSet the Argument expression property to the field you group the data by.

eurd-win-shaping-group-count-expression

1.Back in the Label Tasks window, you can use the Format String property to format the summary's value:

eurd-win-shaping-group-count-format-string

You can see the group count in the report footer when switching to Print Preview.

eurd-win-shaping-group-count-result