Report Subtotals

Subtotals display formats

Subtotals can be displayed on printable report formats: Adobe PDF, Printable Excel, and Printable HTML.

Subtotals appear underneath each column selected for display.

Subtotals display the sum of numeric data for the selected fields.

Subtotals display the maximum value of numeric data for the selected fields.

Subtotals display the minimum value of numeric data for the selected fields.

Subtotals display the average of numeric data for the selected fields.

Video: Using Subtotals (1.5 min).

Display options for per-group totals

The subtotal page can be used to turn on or off two options that provide the total number of records per group.

This feature is particularly useful for reports that group registrations by company.

By selecting the option "Display number of records next to each group," you can easily tell how many attendees are coming to the event from each company.

You may also choose to "Display grand total number of records at the bottom of the report."

Subtotals for specific data fields

You can display subtotals for the following columns that contain numeric data, such as Total Payments and Balance Due for Registration reports, or the number of attendees who selected a particular program item on a Registration Agenda report.

To show the subtotals for a particular data field, select the check box for Sum, Maximum, Minimum, or Average.

You may select multiple check boxes.

The subtotals will be displayed in a row beneath each report grouping, or at the bottom of the report if no groupings are designated.

Note about Groups and Changes Reports

Note: Groups and Subtotals are ignored when running a Changes Report with the "Return Changes Since" option.

If the report’s setup includes Groups or Subtotals, Subtotals are not included, and Groups are treated as columns in the front of the record set, and ignored in the results rendering.

This behavior is the same as when a report with Groups or Subtotals is displayed in the Report Results window, since these options are intended for exported report results.

Feedback

Was this article helpful? Yes No

0 out of 0 found this helpful

Have more questions? Submit a request

Reports FAQ - Generating Reports

Comments

0 comments

Please sign in to leave a comment.

---

Certain Help Center [Note: Navigation elements and footer content removed per instructions.]