The Totals configuration allows you to use columns to sum, average, count and total the data on a report.
Access the Configuration Options window for the desired enhanced report.
In the Configuration Options list on the left, select Totals.
The Totals window appears.
Note: The Totals options (columns) available for selection are different on each report.
Modify the Totals options as needed for the report.
Select a column, and then select one of the following check boxes for the column:
Sum
Average
Count
Totals
The sum, average, count or total prints at the bottom of the column on the sub-total line for each grouping throughout the report, and on the grand total line at the end of the report.
Note: The check boxes are disabled for columns that cannot be summed, averaged, counted or totaled.
Modify the Report Total Caption, if needed. The caption prints in front of the grand total at the end of the report. The default value is TOTAL.
Modify the Sub Total Prefix, if needed. The caption prints in front of the total for each grouping throughout the report. The default value is Totals for.
To display the report without detail, select the Total Lines Only check box. The report displays only a sub-total line for each grouping on the report, and a grand total line at the end of the report.
To display the number of data records on the report, select the Counts Records check box. The number of records prints in parentheses on the sub-total line for each grouping throughout the report, and on the grand total line at the end of the report.
When finished, do one of the following:
To configure additional filters for the report, select the desired Configuration Options on the left.
To generate the report, select the Refresh Report button.
