Enform Plus Reference Manual

Statements
Enform Plus Reference Manual—422684-001
4-36
Optional Clauses
can be modified by the NOPRINT clause if desired. Of course, you must also set
@SUMMARY-ONLY to OFF. For example:
SET @SUMMARY-ONLY TO OFF;
LIST BY dept, BY job, BY empname, salary NOPRINT,
COUNT (empname OVER job);
returns more than one record for each job in each department. All the employee names
(empname) for each job are returned, as follows:
COUNT
DEPT JOB EMPNAME EMPNAME
---- --- ------- -------
0101 MANAGER JACK RAYMOND 2
TIM WALKER
SALESMAN JIM HERMAN 2
TOM HALL
SECRETARY KATHRYN DAY 1
SYS.-ANAL LARRY CLARK 1
0102 MANAGER TONY CRAFT 1
SALESMAN GEORGE FORSTER 1
0201 MANAGER DAVID STRAND 2
JERRY HOWARD
PROGRAMMER SUSAN CHAPMAN 1
Optional Clauses
These clauses are optional and are described in Section 5, Clauses. If you use one of
these clauses to modify a target-item that contains a subscript range, the clause
modifies each element in the range. Briefly, the clauses do the following:
•
AFTER CHANGE clause prints information preceding the records for each by-item
within a printed report.
•
AS clause specifies the display format for a target-item or a by-item.
•
AS DATE clause specifies the date format for printing a date.
•
AS TIME clause specifies the time format for printing a time.
•
AT END PRINT clause prints information at the end of a report.
•
AT START PRINT clause prints information at the beginning of a report.
•
BEFORE CHANGE clause prints information following the records for each by-
item within a printed report.
•
CENTER clause centers an object within its context.
•
CUM clause prints a running total for a target-item or by-item.
•
FOOTING clause prints a footing for a report.
•
HEADING clause specifies a column heading for a report.