TOTAL
From CometWiki
(New page: TOTAL Syntax: TOTAL field-name[,P][;field-name{,P}][;field-name{,P}] Where: P = print a message (string) on the total line Placement: Place the TOTAL command after the REPORT comma...) |
|||
| Line 1: | Line 1: | ||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | Line continuation | + | == TOTAL == |
| + | |||
| + | '''Syntax:''' <br> TOTAL field-name[,P][;field-name{,P}][;field-name{,P}] <br> | ||
| + | '''Where:''' <br> P = print a message (string) on the total line <br> | ||
| + | '''Placement:''' <br> Place the TOTAL command after the REPORT command and immediately after the PRINT command containing the fields you wish to total. <br> | ||
| + | '''Discussion:''' <br> The TOTAL command produces grand total, subtotals, and column totals.<br> Follow the TOTAL command with the field-name or expression you wish to total. <br> You can also use the optional "P" parameter to print a message or string value along with the total in the report. <br> | ||
| + | |||
| + | You can use the BREAK and TOTAL commands together without a PRINT command to produce summary reports.<br> A summary report provides one total line each time the data in the break field changes. | ||
| + | |||
| + | '''Line continuation''' | ||
To continue the TOTAL command to the next line, end the line with a ";" and continue on the next line. | To continue the TOTAL command to the next line, end the line with a ";" and continue on the next line. | ||
Latest revision as of 11:14, 6 June 2009
TOTAL
Syntax:
TOTAL field-name[,P][;field-name{,P}][;field-name{,P}]
Where:
P = print a message (string) on the total line
Placement:
Place the TOTAL command after the REPORT command and immediately after the PRINT command containing the fields you wish to total.
Discussion:
The TOTAL command produces grand total, subtotals, and column totals.
Follow the TOTAL command with the field-name or expression you wish to total.
You can also use the optional "P" parameter to print a message or string value along with the total in the report.
You can use the BREAK and TOTAL commands together without a PRINT command to produce summary reports.
A summary report provides one total line each time the data in the break field changes.
Line continuation
To continue the TOTAL command to the next line, end the line with a ";" and continue on the next line.
