Badge at 11:14, 6 June 2009

2009-06-06T11:14:36Z

← Older revision		Revision as of 11:14, 6 June 2009
Line 1:		Line 1:
-	~~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	+	== 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.

Badge: 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...

2009-06-05T13:14:41Z

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...

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 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.

TOTAL - Revision history

Badge at 11:14, 6 June 2009

Badge: 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...