Page History
...
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
| Code Block |
|---|
/* 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) |
