In this step, you request that CA OLQ skip to a new page after each change in the group field.
Before you specify this option, you must establish a current group field and group level.
|
Step |
What To Do |
How To Do It |
|---|---|---|
|
1 |
Go to the Report Format - Group By screen. |
Type group by in the command line of any screen. |
|
2 |
Establish the current group field and level. |
|
|
3 |
Ask CA OLQ to skip to a new page after a computation. |
Enter pg in the Skip lines after group field. |
Specify employee.dept-id as your current group field. Specify 1 as the current group level.
CA OLQ Release nn.n *** Report Format - Group By *** -> Page 1 OF 2 136000 Specify summary computations and press the ENTER key Group by: employee.dept-id Level# 1 Seq Sum Avg Max Min Count _ EMPLOYEE X EMP-LAST-NAME _ _ _ _ X DEPT-ID 1 _ _ _ _ X SALARY-AMOUNT 4 _ _ _ _ X 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 MPLOYEE.SALARY-AMOUNT) GROUP BY EMPLOYEE.DEPT-ID LEVEL 1 Skip lines after group 1 Separator character - Compute: 1=HELP 3=QUIT 4=MESSAGE 5=DISPLAY 6=MENU 8=FWD 10=PICTURE
Type sort in the command line. CA OLQ echoes the screen, listing the current group field and level. Type pg next to Skip lines after group to specify that you want CA OLQ to skip a page after each change in the current group field (DEPT-ID).
CA OLQ Release nn.n *** Report Format - Group By *** -> sort Page 1 OF 2 136000 Specify summary computations and press the ENTER key Group by: EMPLOYEE.DEPT-ID Level# 1 Seq Sum Avg Max Min Count _ EMPLOYEE X EMP-LAST-NAME _ _ _ _ X DEPT-ID 1 _ _ _ _ X SALARY-AMOUNT 4 _ X _ _ X 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 MPLOYEE.SALARY-AMOUNT) GROUP BY EMPLOYEE.DEPT-ID LEVEL 1 Skip lines after group pg Separator character - Compute: 1=HELP 3=QUIT 4=MESSAGE 5=DISPLAY 6=MENU 8=FWD 10=PICTURE
Type a character next to Summary to restore the display of lines containing summary computations.
CA OLQ Release nn.n *** Report Format - Sort *** -> Page 1 of 2 133000 Specify sort or group by request and press the ENTER key Disp Sort Order Group By Seq Priority (A/D) Level # EMPLOYEE X EMP-LAST-NAME 3 A _ X DEPT-ID 1 1 A 1 X SALARY-AMOUNT 4 _ _ _ X PROJECT 2 A 2 COMPUTE FIELDS: X TOTAL-3-ALL=TOTAL(EMPLOYEE.SALARY-AM OUNT) GROUP BY ALL LEVEL 1 X 'EMPLOYEE.SALARY-AMOUNT-AVE-2'=AVE(E MPLOYEE.SALARY-AMOUNT) GROUP BY EMPLOYEE.DEPT-ID LEVEL 1 Display lines: Detail X and/or Summary x Group by all X Compute: 1=HELP 3=QUIT 4=MESSAGE 5=DISPLAY 6=MENU 8=FWD 11=HEADER
CA OLQ displays each department's statistics on a separate page. Press [PF8] to page through the whole report.
CA OLQ Release nn.n *** Display Report *** -> Page 1 Line 1 104009 DISPLAY RIGHT to see more report columns 125000 Press the ENTER key to go to the next page of the report. EMPLOYEE REPORT mm/dd/yy DEPT-ID SALARY-AMOUNT EMP-LAST-NAME ─────── ─────────────────────────────────── ─────────────── 4000 37000.00 ZEDI 18000.00 ANGELO 34000.00 JACKSON 18000.00 MCDOUGALL 39000.00 PENMAN 80000.00 BANK ─────────── AVERAGE SALARY: 37666.66 - 1 - 1=HELP 3=QUIT 4=MESSAGE 6=MENU 8=FWD 10=LEFT 11=RIGHT
CA OLQ Release nn.n *** Display Report *** -> Page 2 Line 13 125000 Press the ENTER key to go to the next page of the report. EMPLOYEE REPORT mm/dd/yy DEPT-ID SALARY-AMOUNT EMP-LAST-NAME ─────── ─────────────────────────────────── ─────────────── 5200 38000.00 CLOTH 31000.00 KASPAR 45000.00 FINN 33000.00 TIME 80000.00 WILCO ─────────── AVERAGE SALARY: 45400.00 - 2 - 1=HELP 3=QUIT 4=MESSAGE 6=MENU 7=BWD 8=FWD 10=LEFT 11=RIGHT
|
Copyright © 2013 CA.
All rights reserved.
|
|