Running Total How-Tos
A running total is inserted in a Report Design file using the Running Totals window. This window operates in auto-hide mode by default. For more information, see Auto-Hide Windows.
You create a running total to sum the values for a numeric field for each record that is printed in the Details section of the Report Design file. A running total starts at zero and is computed each time the record changes. For example, if the first three records have values of 2,4, and 6, the running total of these three records would be 2, 6, and 12, respectively. A running total can be reset to zero after each Group Header.
While running totals are similar to summary fields, they allow more control over how the total is calculated and when it is reset. Using a running total, you can total a value independent of the report’s grouping, total a value conditionally, total a value after a group selection formula has been applied, or total a value from a related table in a one-to-many linking relationship.
The following topics describe how to use running totals: