Placement of running total fields

The calculation of a Running Total field is determined by the settings selected in the Running Total Expert. However, where you place the running total affects the value that appears on the report. For example, if a Running Total field 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 field in the Report Footer returns the desired value. The Running Total field 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 Header

Returns first record of the report

Page Header

Creates running total up to and including the first record of current page.

Group Header

Creates running total up to and including first record of current group.

Details

Creates running total for every record.

Group Footer

Creates a grand total for each group.

Page Footer

Creates Running total up to and including the first record of the next page.

Report Footer

Creates a grand total that includes all records.



Seagate Software, Inc.
http://www.seagatesoftware.com
Please send comments to:
techpubs@seagatesoftware.com