How to: |
Reference: |
A report request may include a field to create a certain result. For example, it may name a sort field by which to arrange data. However, you may not want to display the title or values of that field if they appear elsewhere in the report. The phrase NOPRINT (synonym SUP-PRINT) suppresses column display.
Command |
Description |
Applies to |
---|---|---|
NOPRINT or SUP-PRINT |
Suppresses column display. |
HTML PS |
display_command fieldname {NOPRINT|SUP-PRINT}
or
{ON|BY} fieldname {NOPRINT|SUP-PRINT}
where:
Is a display command.
Is a display field or sort field. The field values are used but not displayed. A HOLD file will not contain the values of a suppressed BY field.
For a calculated value with NOPRINT, repeat AND COMPUTE before the next calculated value if applicable.
Suppresses column display. The terms are synonymous.
Is a vertical sort phrase. The terms are synonymous.
This request sorts data by city. Since the page heading contains the name of the city, the sort field occurrence is suppressed.
TABLE FILE SALES HEADING "Page <TABPAGENO" "SALES REPORT FOR <CITY" PRINT UNIT_SOLD AND DELIVER_AMT BY CITY PAGE-BREAK NOPRINT BY PROD_CODE ON TABLE SET STYLE * TYPE=REPORT, GRID=OFF, $ ENDSTYLE END
The page heading identifies the city to which the data applies:
Without NOPRINT, the report would unnecessarily repeat the city:
This request generates a subtotal for each value of the sort field CATEGORY but suppresses the display of the sort field occurrence.
TABLE FILE GGSALES SUM UNITS BY CATEGORY BY PRODUCT ON CATEGORY SUB-TOTAL SUP-PRINT PAGE-BREAK ON TABLE SET PAGE-NUM OFF ON TABLE SET STYLE * TYPE=REPORT, GRID=OFF, $ ENDSTYLE END
The default subtotal line identifies each category (for example, *TOTAL Coffee):
Without SUP-PRINT, the report would unnecessarily repeat the category:
This request sorts last names alphabetically but avoids duplication of data by suppressing the sort field occurrence of LAST_NAME.
TABLE FILE EMPLOYEE PRINT LAST_NAME BY LAST_NAME NOPRINT ON TABLE SET PAGE-NUM OFF ON TABLE SET STYLE * TYPE=REPORT, GRID=OFF, $ ENDSTYLE END
Last names are arranged alphabetically: