DET-SUPP or D will always suppress detail lines when used in a query. When DET-SUPP or D is used in a query that contains the BREAK-ON or TOTAL modifiers, only the break lines or the total lines are displayed.
|
NOTE |
When the D option is used with the COPY or COPY-LIST commands, it deletes the source items after copying them. |
Example
All orders are sorted by title and the amount is then totalled for each title, but the report only prints each title once with the total amount. Detail lines for each order are not printed.
|
>SORT ORDERS BY-EXP TITLE BREAK-ON TITLE TOTAL AMOUNT DET-SUPP |
||
|
|
|
|
|
PAGE 1 |
11:49:22 DD MMM YYYY |
|
|
|
|
|
|
ORDERS.... |
TITLE................................................... |
AMOUNT.... |
|
|
|
|
|
|
DATABASE MANAGEMENT SYSTEMS |
$3146.00 |
|
|
|
|
|
|
OPERATING SYSTEM CONCEPTS |
$3914.00 |
|
|
|
|
|
|
WORD PROCESSING |
$2724.00 |
|
|
|
|
|
|
WRITING COMMERCIAL APPLICATIONS |
$2844.00 |
|
*** |
|
$12628.00 |
|
|
|
|
|
35 ITEMS LISTED. |
|
|
|
|
|
|
|
> |
|
|
See Also