#### 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