Description

Grand-Total changes the text that accompanies the final total generated by the Total keyword within a Run_Report statement..

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.

OptionDescription
textSubstitutes text for the three asterisks normally printed. The text will be truncated to fit into the column width of the leftmost column.
optionsThe following options enclosed within double quotes are available:
 
OptionDescription
'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.

Note: Grand-Total 'L' suppresses a line, while the Heading 'L' option causes a blank line to be inserted.

'P'Page. Prints the grand total on a new page.

Example

/*This command will list all CUSTOMERS by order of state, putting a break between each state. 
At each break, the TOTAL invoice balance for all customers in that state will be displayed. 
A Grand-Total will be displayed at the end of the report with the text Grand Total*/
stmt = 'LIST CUSTOMERS CUSTOMER_NAME BY STATE BREAK-ON STATE TOTAL '
stmt:= 'INVOICE_TOTAL GRAND-TOTAL "Grand Total"'
Run_Report("",stmt)
  • No labels