Enform Plus Reference Manual

Statements
Enform Plus Reference Manual—422684-001
4-35
Summary Reports
When you explicitly request a summary report, you get a report summarized down to the
lowest level where an aggregate is calculated over that level. For example:
SET @SUMMARY-ONLY TO ON;
LIST BY dept, BY job, BY empname, salary,
COUNT(empname OVER job);
returns one record for each job in each department. Only the first employee name
(empname) for each job is returned, as follows:
COUNT
DEPT JOB EMPNAME SALARY EMPNAME
---- --- ------- ------ -------
0101 MANAGER JACK RAYMOND 36000 2
SALESMAN JIM HERMAN 19000 2
SECRETARY KATHRYN DAY 12000 1
SYS.-ANAL LARRY CLARK 25000 1
0102 MANAGER TONY CRAFT 37000 1
SALESMAN GEORGE FORSTER 30000 1
0201 MANAGER DAVID STRAND 39000 2
PROGRAMMER SUSAN CHAPMAN 17000 1
When you implicitly request a summary report, you also get a report summarized down
to the lowest level where an aggregate is computed over that level. (A query requesting
only by-items and aggregates over ALL is not an implicit request for a summary report.)
For example:
SET @SUMMARY-ONLY TO OFF;
LIST BY dept, BY job, BY empname,
COUNT (empname OVER job);
returns one record for each job in each department. Again, only the first employee name
(empname) for each job is returned:
COUNT
DEPT JOB EMPNAME EMPNAME
---- --- ------- -------
0101 MANAGER JACK RAYMOND 2
SALESMAN JIM HERMAN 2
SECRETARY KATHRYN DAY 1
SYS.-ANAL LARRY CLARK 1
0102 MANAGER TONY CRAFT 1
SALESMAN GEORGE FORSTER 1
0201 MANAGER DAVID STRAND 2
PROGRAMMER SUSAN CHAPMAN 1
If you want a report that consists of only by-items and aggregates to contain all report
lines (including those where the last value of a by-item has not changed but a
subordinate by-item value has changed), then you must include a target-item in
the target-list that has not appeared as a by-item or aggregate. This target-item