The GRAND TOTALS ON Statement

2 Report Description Statements

The GRAND TOTALS ON Statement

The GRAND TOTALS ON statement provides a means of having the Eloquence Report Writer do automatic totaling for the entire report. The GRAND TOTALS ON statement may only appear once, directly following the REPORT HEADER statement. Once executed, the GRAND TOTALS ON statement allows two special functions to be used: TOTAL and AVG (described in page 53 ). All totals are zero at the beginning of the report execution and are accessible at any time while the report is active. Totals are incremented during the execution of a DETAIL LINE 1-9 after all breaks are serviced but before control is passed to the USING part of the statement.

GRAND TOTALS ON

The parameter is:

exp: Any valid number variable or expression.

An example of this statement follows.

60  Inv: REPORT HEADER
70       GRAND TOTALS ON Qty,Qty$\ast$Price

Each time a DETAIL LINE statement (with a number of 1 through 9) is encountered the values of Qty and Qty$\ast$Price are added to the totals kept by the GRAND TOTALS ON statement.

Eloquence Report Manual - 19 DEC 2002