Description
Total is used to generate the sum of a numeric column and display it at the end of a report generated through Run_Report. If a Break-On has been specified, Total will also display subtotals at each break point.
Syntax
Total COLUMN
Remarks
Total will accumulate the value of each column being totaled, and display the result at the end of the report. If a Break-On has been specified, Total will also output subtotals at each Break-On. Note in the examples that the Break-On and Total columns can be different. The final total appears at the end of the report, and is identified by three asterisks (***in the leftmost column of the report. To substitute an option for the three asterisks, refer to Grand-Total. Any number of columns can be totaled in the report. Total can be used with the modifier DET-SUPP (detail suppress) to create reports with only total values.
Examples
/* 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. */
stmt = 'LIST CUSTOMERS CUSTOMER_NAME BY STATE BREAK-ON STATE '
stmt:= 'TOTAL INVOICE_TOTAL'
Run_Report("",stmt)
