Adding a Count to a Report Group

You can use the Report Designer to create Counts for groups of results. For example, you can group Incidents by Team ownership and then add a Count to calculate the number of Incidents owned per Team.

To add a Count to a Report Group:

1. In the Report Manager, right-click a Report, and then select Design Report.
2. Select the band to add the Group to, and then click the Add a Group button.
3. From the list of Fields that opens, select the Field you want to Group results by.

   Example: Select Owned_by_Team.

4. From the Field List pane, drag the Fields you want to display as labels on to the Group Header band. Also, add the Field you want to use to count the number of results in the Group.

   Example: Drag Owned_by_Team and Incident_ID to the Group Header band.

5. Select the Field you want to use for your Count.

   Example: Select Incident_ID.

6. Use the Data area of the Property Grid settings to set the following options:

   Option	Description
   Summary	Expand, and then select: Running>Group Function>Count
   Text Format String	Select the ellipses to open the Format String Editor so you can format your label. Example: Select General, and then provide a prefix, such as "Total: {0}." Notice the right pane shows an preview of your label and data.
   Ignore null values	Select yes to ignore empty values; select no to include empty values.
   Summary Running	Choose to show the summary of results by: Page: Shows the count by the number of results per Report page. Group: Shows the count by the number of results for each Group. Report: Shows the count by the number of results in the entire Report. None Hides the count. Example: Select Group to show the number of Incidents owned by each Team.

7. Click OK.