GRAND-TOTAL is an output modifier that specifies text to be printed on the Grand Total line of a report. The specified text is printed left-justified in the first column of the report, replacing the three asterisks that normally appear.
|
NOTE |
Text entered for the Grand Total should not exceed the character-width specification for the first column; it could overwrite the total figures. |
Format
|
GRAND-TOTAL " [text] ['options'] [text] " |
Parameter(s)
|
text |
Text to be printed on the Grand Total line of the report. |
|
|
options |
Must be enclosed in single quotes. |
|
|
L |
(Line) Suppresses the blank line that precedes the Grand Total line. This option is ignored if the U option is used in the same query. |
|
|
P |
(Page) Prints Grand Totals on a separate page. |
|
|
U |
(Underline) Underlines all totalled attributes with a row of equal signs. |
|
Description
The entire string of text and options must be enclosed in double quotes.
Example
This example report includes a Grand Total line that reads TOTAL SALES, and incorporates the U option:
|
>SORT ORDERS BY-EXP TITLE BREAK-ON TITLE TOTAL AMOUNT GRAND-TOTAL "TOTAL SALES:'U' " |
||
|
|
|
|
|
PAGE 3 15:35:18 DD MMM YYYY |
||
|
|
|
|
|
ORDERS... |
TITLE................................................ |
AMOUNT.... |
|
|
|
|
|
10108 |
WRITING COMMERCIAL APPLICATIONS |
$236.50 |
|
10110 |
WRITING COMMERCIAL APPLICATIONS |
$1301.13 |
|
10112 |
WRITING COMMERCIAL APPLICATIONS |
$229.25 |
|
10120 |
WRITING COMMERCIAL APPLICATIONS |
$196.00 |
|
10122 |
WRITING COMMERCIAL APPLICATIONS |
$49.00 |
|
10123 |
WRITING COMMERCIAL APPLICATIONS |
$49.00 |
|
|
|
|
|
*** |
|
$3259.11 |
|
|
|
========= |
|
TOTAL SALES: |
|
$14084.67 |
|
|
|
|
|
35 ITEMS LISTED. |
|
|
|
|
|
|
|
> |
|
|
See Also