Crystal Reports  

Placement of Running Total Fields

The calculation of a running total field is determined by the settings selected in the Running Total Expert. However, your placement of the running total affects the actual value that appears on the report. For example, if you place a running total that evaluates every record and never resets (a grand total) in the Report Header, only the value of the first record will appear. Placing the same running total in the Report Footer returns the desired value. The running total is properly calculated in both cases, but it is displayed too soon in the first case.

The following is a list of the report sections and the records that the running total will use.

Report Section Running Total Calculated For
Report Header The first record in the report.
Page Header All records up to and including the first record on the current page.
Group Header All records up to and including the first record in the current group
Details All records up to and including the current record.
Group Footer All records up to and including the last record in the current group.
Page Footer All records up to and including the last record on the current page.
Report Footer All records in the report.

See Also

Creating Running Totals in a List | Creating Running Totals for a Group | Creating Conditional Running Totals