GRAND-TOTAL Modifier

The GRAND-TOTAL modifier specifies text to replace the default asterisks in the cumulative total line at the end of a report.

CAPTION is a synonym for GRAND-TOTAL.

Syntax

GRAND-TOTAL "{text}{'option{option}...'}{text}"

Syntax Elements

text comprises all printable characters except return, line feed, double quote, single quote, and the system delimiters.

option is a GRAND-TOTAL option.

Options

L Line. Suppresses the blank line preceding the GRAND-TOTAL line. Overrides the U option if both are specified.

P Page. Outputs the GRAND-TOTAL on a separate page.

U Underline. Puts underlines on the line above the accumulated totals. Ignored if used with the L option.

Example

If the GRAND-TOTAL modifier is added to the example provided for the TOTAL modifier, the result is as follows:

:SORT GUESTS WITH BILL-CODE = "18" BY ROOM BILL-CODE TOTAL 
BILL-AMOUNT GRAND-TOTAL "Total" LAST-NAME HDR-SUPP

GUESTS  Bill   Amount   Last Name
        Code
               *  
117        2   $62.00   Rizzo
           6   $17.95
          18    $8.76
140        2   $55.00   Lynch
           6   $34.95
           9   $17.00
          18   $18.76
143       15   $12.95   Hennessey
          12   $22.50
          18    $2.95
           8    $7.95
Total         $260.77