Add Report Totals

Calculates summaries (totals) in a report.

1. If the Report Footer band is not already present in the report, it must be added. Right-click anywhere on the report, select Insert Band and ReportFooter from the drop-down menus.

   

2. On the Detail area of the report, select the field item for which a summary is to be calculated. Hold down Ctrl and drag the field item onto the ReportFooter area of the report to create a copy which will display the summary.

   

   Note:
   A new label can also be created for the summary by dragging it from the Toolbox.

3. On the ReportFooter area of the report, select the field item. On the Properties window, click the Database tab.

   

4. Set the Running property to define the calculated values. The available values are Report, Page and Group. The default value is Report which calculates the value using all instances of the specified data field.

5. Set the Function property to define the type of calculation used.

6. Set the Ignore Null Values and Treat Strings as Numerics values using the check boxes.

   Note:
   The Ignore Null Values option does not affect the result in this example, since by default NULL values are treated as if they were zeros. So the Sum is not 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 controls counted.

7. Click the ellipsis next to Format String to display the Format String Editor window.

   

8. Select the required format style and click OK to close the Format String Editor window and save the changes.

9. Click the Print Preview tab to display a preview of the current report layout with the modified report control.