In this step, you modify the default headers for your group computations.
Computations with ALL as the group field are not assigned a default header. All other group computations are assigned default headers. These headers include:
For example, the default header for the average salary for each department is:
'AVE FOR $EMPLOYEE.DEPT-ID'
This header would look like this for department 5200:
AVE FOR 5200 :
The default headers are listed on the Report Format - Header screen. To get there, type header in the command line of any screen.
CA OLQ Release nn.n *** Report Format - Header *** -> Page 1 of 2 134000 Specify column headers and press the ENTER key Underline character: - Disp Seq Header EMPLOYEE X EMP-LAST-NAME 3 EMP-LAST-NAME X DEPT-ID 1 DEPT-ID X SALARY-AMOUNT 4 SALARY-AMOUNT X PROJECT 2 PROJECT COMPUTE FIELDS: X TOTAL-3-ALL=TOTAL(EMPLOYEE.SALARY-AM OUNT) GROUP BY ALL LEVEL 1 X 'EMPLOYEE.SALARY-AMOUNT-AVE-2'=AVE(E 'AVE FOR $EMPLOYEE.DEPT-ID:' MPLOYEE.SALARY-AMOUNT) GROUP BY EMPLOYEE.DEPT-ID LEVEL 1 Compute: 1=HELP 3=QUIT 4=MESSAGE 5=DISPLAY 6=MENU 8=FWD 10=SORT 11=EDIT CA OLQ Release nn.n *** Report Format - Header *** -> Page 2 of 2 134000 Specify column headers and press the ENTER key Underline character: - Disp Seq Header COMPUTE FIELDS: X 'EMPLOYEE.PROJECT-COUNT'=COUNT 'COUNT FOR $EMPLOYEE.PROJECT:' GROUP BY EMPLOYEE.PROJECT LEVEL 2 Compute: 1=HELP 3=QUIT 4=MESSAGE 5=DISPLAY 6=MENU 7=BWD 10=SORT 11=EDIT
Specify more legible labels for your report total and department computations.
CA OLQ Release nn.n *** Report Format - Header *** -> Page 1 of 2 134000 Specify column headers and press the ENTER key Underline character: - Disp Seq Header EMPLOYEE X EMP-LAST-NAME 3 EMP-LAST-NAME X DEPT-ID 1 DEPT-ID X SALARY-AMOUNT 4 SALARY-AMOUNT X PROJECT 2 PROJECT COMPUTE FIELDS: X TOTAL-3-ALL=TOTAL(EMPLOYEE.SALARY-AM 'TOTAL SPENT IN SALARIES:' OUNT) GROUP BY ALL LEVEL 1 X 'EMPLOYEE.SALARY-AMOUNT-AVE-2'=AVE(E 'AVERAGE SALARY:' MPLOYEE.SALARY-AMOUNT) GROUP BY EMPLOYEE.DEPT-ID LEVEL 1 Compute: 1=HELP 3=QUIT 4=MESSAGE 5=DISPLAY 6=MENU 8=FWD 10=SORT 11=EDIT
Specify a more legible label for your project computation. In this example, the label contains a variable field ($EMPLOYEE.PROJECT) for the project name.
CA OLQ Release nn.n *** Report Format - Header *** -> Page 2 of 2 134000 Specify column headers and press the ENTER key Underline character: - Disp Seq Header COMPUTE FIELDS: X 'EMPLOYEE.PROJECT-COUNT'=COUNT 'WORKING ON $EMPLOYEE.PROJECT:' GROUP BY EMPLOYEE.PROJECT LEVEL 2 Compute: 1=HELP 3=QUIT 4=MESSAGE 5=DISPLAY 6=MENU 7=BWD 10=SORT 11=EDIT
CA OLQ displays a new label for your project groups.
CA OLQ Release nn.n *** Display Report *** -> Page 1 Line 1 125000 Press the ENTER key to go to the next page of the report. EMPLOYEE REPORT mm/dd/yy DEPT-ID PROJECT EMP-LAST-NAME ─────── ─────────────────────────────── ─────────────── 4000 EVALUATE ZEDI ─────────── WORKING ON EVALUATE: 1 PLANNING ANGELO JACKSON MCDOUGALL PENMAN ─────────── WORKING ON PLANNING: 4 TESTING BANK ─────────── WORKING ON TESTING : 1 - 1 - 1=HELP 3=QUIT 4=MESSAGE 6=MENU 8=FWD 10=LEFT 11=RIGHT
CA OLQ displays a new label for your department computations and for your report total.
CA OLQ Release nn.n *** Display Report *** -> Page 2 Line 13 125004 Press the ENTER key for DISPLAY/FORMAT ACTIVITY selections EMPLOYEE REPORT mm/dd/yy EMP-LAST-NAME SALARY-AMOUNT ─────────────── ─────────────────────────────────── CLOTH 38000.00 KASPAR 31000.00 FINN 45000.00 TIME 33000.00 WILCO 80000.00 ─────────── AVERAGE SALARY: 45400.00 ___________ TOTAL SPENT IN SALARIES: 453000.00 - 2 - 1=HELP 3=QUIT 4=MESSAGE 6=MENU 7=BWD 10=LEFT 11=RIGHT
Note that if you lengthen your header, the column width lengthens accordingly. If you make your headers too long, this can make your report difficult to read.
|
Copyright © 2013 CA.
All rights reserved.
|
|