Grand-Total
Description
Grand-Total changes the text that accompanies the final total generated by the Total keyword.
Syntax
Grand-Total "text['options']"
Remarks
Use the Total keyword to display a total at the bottom of the report (in addition to any subtotals generated). The final total at the end of the report will be marked by the display of three asterisks (***) in the leftmost column of the report. Use the Grand-Total keyword to change the output from three asterisks to some other text.
| Option | Description |
|---|---|
| text | Substitutes text for the three asterisks normally printed. The text will be truncated to fit into the column width of the leftmost column. |
| options | The following options enclosed within double quotes are available: Option : Description 'L' : Line - Suppresses the blank line that usually precedes the grand total line. This is useful when it is desirable to condense a report. This option does not override the 'U' option. 'P' : Prints the grand total on a new page. 'U' : Underline - Prints a row of equal signs ( === ) under the grand total. 'UU' : Overline/Underline - Prints a row of equal signs ( === ) over and under the grand total. Note: Grand-Total 'L' suppresses a line, while the Heading 'L' option causes a blank line to be inserted. |
Example
The phrase "Invoice Total" will be printed in the leftmost column of the report at the end, across from the total value for the INVOICE_AMOUNT column. If the leftmost column of the report is narrower than 13 columns, the phrase will be truncated.
List CUSTOMERS Total INVOICE_AMOUNT Grand-Total "Invoice Total"