The report section count can found in the bottom-right corner of a report section.

By default, this count represents the total rows within the section. Note: If the report's root and connecting form structure does not meet recommended best practices, there could be duplicated rows that inflate the total row count. To learn more about root forms, click here.

Follow the steps listed below to learn what options are available to display in a report section count.

Within the report, click the green gear icon to the right of the report section's name.

This will open the Section Properties pop-up window.

In the Count section, the 'Total Rows' option is selected by default. This adds up the number of rows included in your report section. If your report contains both Tier 1 and Tier 2 records, Total Rows will count all combinations of Tier 1 records and their associated Tier 2 records.

You will also find options to instead pull a record count for each form that's been pulled into the report.

If you prefer to count only the Tier 1 records pulled into the report, select the Tier 1 form's records in this setting. In the example report, the 'Household Profile Records' option would just count Tier 1 records.

If you want to count the total number of times that a particular service was provided, you can instead select a Tier 2 form's records.

You can also remove the report section count altogether by selecting 'Suppress Total Row Count'. This option will expand to give you the ability to choose when this count is suppressed. You can select multiple options, including:

Note: The Total Rows count is typically exported as a separate tab in an Excel spreadsheet, so suppressing the count when exporting would remove the dedicated tab.

Once you've made your selections, select Apply to return to your report.

Finally, save and publish your report from the Report Actions palette to run your report with these settings.