The preceding topic demonstrated the default appearance of a grand total line in a report. The GRAND-TOTAL modifier may be used to specify a different format.
Format
|
GRAND-TOTAL " text ['options'] [text] " |
Parameter(s)
|
text |
String to appear in place of the three asterisks in the item-ID column of the total line. Enclose this parameter in double quotes. Text may appear on either side of the specified options. |
|
|
options |
Some combination of these options, enclosed in a set of single quotes: |
|
|
U |
Underlines the line above the totalled fields with equal signs (=). |
|
|
L |
Suppresses the blank line that precedes the total line. This option is ignored if the U option is used. |
|
|
P |
Begins a new page for the total line. |
|
Description
These options must be specified within the text parameter and the outer set of double quotes.
Assume the user wants to reformat the total line from the preceding example. The following query shows the last page of a report and identifies the total line with the text LARGE ORDER TOTAL:, includes underlining above the total figure, and prints it on a separate page:
|
>LIST ORDERS CUST.ID TITLE TOTAL TOTAL.AMT > "250.00" GRAND-TOTAL "LARGE ORDER TOTAL: 'UP'" |
|||
|
|
|
|
|
|
PAGE 2 |
11:43:26 DD MMM YYYY |
||
|
|
|
|
|
|
ORDERS |
Customer ID |
Title.................... |
Amount |
|
10113 |
HJENK7129 |
OPERATING SYSTEM CONCEPTS |
$373.74 |
|
|
|
WORD PROCESSING |
|
|
10116 |
JBUCK6488 |
WORD PROCESSING |
|
|
10122 |
JBUCK6488 |
WRITING COMMERCIAL APPLICATIONS |
|
|
10110 |
JBOHA5422 |
OPERATING SYSTEM CONCEPTS |
$1301.13 |
|
|
|
WRITING COMMERCIAL APPLICATIONS |
|
|
|
|
WORD PROCESSING |
|
|
|
|
DATABASE MANAGEMENT SYSTEMS |
|
|
10104 |
MASHX5777 |
DATABASE MANAGEMENT SYSTEMS |
$929.42 |
|
|
|
OPERATING SYSTEM CONCEPTS |
|
|
|
|
WRITING COMMERCIAL APPLICATIONS |
|
|
|
|
WORD PROCESSING |
|
|
10119 |
WGALL6490 |
OPERATING SYSTEM CONCEPTS |
|
|
10102 |
BLEAR6803 |
OPERATING SYSTEM CONCEPTS |
|
|
|
|
DATABASE MANAGEMENT SYSTEMS |
|
|
10105 |
DEDGE6635 |
DATABASE MANAGEMENT SYSTEMS |
$268.81 |
|
|
|
|
|
|
LARGE ORDER TOTAL: |
$3600.15 |
||
|
|
|
|
|
|
23 ITEMS LISTED. |
|
|
|
|
|
|
|
|
See Also