GRAND.TOTAL, GRAND-TOTAL, CAPTION

The GRAND.TOTAL keyword (synonyms GRAND-TOTAL and CAPTION) specifies text to appear at the left edge of the grand total line when any field accumulations (AVERAGE, ENUMERATE, MAX, MIN, PERCENTAGE or TOTAL) are used.

Format

GRAND.TOTAL "text"

where

text	is the text to appear on the grand total line.

The GRAND.TOTAL text may include control options enclosed in single quotes. These are:

L	Suppress the grand total line completely (see also NO.GRAND.TOTAL).

P	Print the grand total line on a new page.

U	Toggle inclusion of the underline above the grand total values.

The default form of the grand total is to show a line of equals signs (=) above the total values. The grand total text appears on the left of this line.

The PICK.GRAND.TOTAL keyword of the OPTION command provides closer compatibility with Pick style systems where there is no underline and the text is displayed on the line that holds the total values.

The U control option inverts inclusion of the underline. Without PICK.GRAND.TOTAL, this mode omits the underline. With PICK.GRAND.TOTAL, the underline is shown.

Example

The command

LIST SALES TOTAL ORDER.VALUE GRAND.TOTAL "TOTAL"

might produce the report below.

LIST SALES TOTAL ORDER.VALUE GRAND.TOTAL "TOTAL" Page 1

SALES..... ORDER VALUE

19845 234.53

19858 845.50

19859 384.43

19887 279.40

19830 324.39

19886 397.23

19866 465.31

TOTAL ===========

2930.79

7 records listed.