Add Totals to a Report

Reporting User Guide

Report Editing Basics : Add Totals to a Report

To calculate summaries (totals) within a report, follow these instructions:

•

If the Report Footer band is not present in a report, it must be added by right-clicking anywhere on the report, and in the Context Menu, selecting Insert Band > ReportFooter.

•

Click the field for which a summary will be calculated, to select it. Then, hold down CTRL and drag the field onto the Report Footer area to create an exact copy of the label that will display the summary.

Note:

A new label can also be created for the total by dragging it from the Control Toolbox.

•

Select the newly created label. In the Property Grid, locate the Summary property and click the ellipsis. The Summary Editor is then displayed.

The following image shows an example of how to set up a total.

Note:

The Summary Running option is set to Report to make sure that all values from the specified data field are taken into account.

Note:

The Ignore NULL Values option will not affect the result in this example, since by default NULL values are treated as if they were zeros. So the Sum will not be affected whether or not these values are taken into account. This option applies to functions like Count or Average, because it affects the number of elements counted.

•

To save the settings and close the window, click OK.

Switch to the Preview tab to view the result.

Note:

Summary field results cannot be used in calculated fields.