GRAND.TOTAL

GRAND.TOTAL, GRAND-TOTAL, CAPTION

Top  Previous  Next

 

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

 

textis the text to appear on the grand total line.

 

 

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

 

LSuppress the grand total line completely (see also NO.GRAND.TOTAL).
PPrint the grand total line on a new page.
UToggle 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.

 

 

See also:

NO.GRAND.TOTAL