Enform Plus Reference Manual

Clauses
Enform Plus Reference Manual—422684-001
5-64
SUPPRESS Clause
SUPPRESS Clause
The SUPPRESS clause allows you to eliminate certain records from being printed in the
report. The records still contribute to the report calculations. This clause is an optional
part of the part of the LIST statement. This clause cannot be used with the FIND
statement. The syntax of the SUPPRESS clause is:
logical-expression
is an expression returning a true or false value. See Logical Expressions on
page 3-22 for more information.
The SUPPRESS clause defines a condition or conditions that prevents specific records
from printing throughout a report. For example, in the following query, the SUPPRESS
clause causes Enform Plus to print only the inventory, part number, and part name where
the inventory is greater than zero:
LIST ASCD inventory,partnum,partname,
SUPPRESS WHERE inventory GT 0;
This query generates the following report:
Part
INVENTORY Number PARTNAME
--------- ------ ------------------
-100 2001 DECIMAL ARITH
-32 6402 TERM CRT PAGE
-16 6201 SYNC CONTROLLER
-1 5504 LP 900 LPM
0 5505 LP 1500 LPM
Enform Plus still includes the suppressed records in AFTER CHANGE and BEGIN
CHANGE clauses, subtotals, totals, and other calculations specified for the report. Note
that the value of the first record of an AFTER CHANGE clause or the last record of a
BEFORE CHANGE clause is used for the print list whether or not that record is printed.
Aggregates cannot be used in a SUPPRESS clause; you can, however, reference a user
variable that has been assigned the aggregate value.
SUPPRESS [ WHERE ] logical-expression