User guide

Formatting a Report
Developing an ENFORM Query
3–52 058058 Tandem Computers Incorporated
Report:
ORDER
NUMBER SALESMAN
------ --------
21 205
25 212
30 222
Suppressing the Printing of a Column Heading
Use the NOHEAD clause to suppress the printing of a column heading. Suppressing a
column heading is useful when you want to fold a line into two lines. The following
example prints state under city and suppresses the printing of the column heading for
state:
OPEN customer;
LIST custnum, custname,
city HEADING "CITY/STATE"/
TAB 31 state, NOHEAD;
Report:
CITY
CUSTNUM CUSTNAME STATE
------- ------------------ --------------
21 CENTRAL UNIVERSITY PHILADELPHIA
PENN
123 BROWN MEDICAL CO SAN FRANCISCO
CALIFORNIA
143 STEVENS SUPPLY DENVER
COLORADO
324 PREMIER INSURANCE LUBBOCK
TEXAS
543 FRESNO STATE BANK FRESNO
CALIFORNIA
Suppressing the Printing of Both the Column Heading and the Element
Use the NOPRINT clause to suppress the printing of both the column heading and the
element. The element modified by a NOPRINT clause still contributes to any
calculations of which it is a part.
The following example generates a report containing a list of employees with the
highest salaries. Since salary is not for public consumption, the NOPRINT clause is
used to suppress the printing of this element:
OPEN employee;
LIST empnum, empname,
DESC salary NOPRINT,
job,
WHERE salary GT 22000;