In this step, you modify the SALARY qfile to suppress the display of all detail lines (those not containing any summary calculations) in the report. Thus the report displays only the average salary for each salary grade.
Type a space next to Detail to suppress the display of detail lines.
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-FIRST-NAME-0415 1 _ _ _ X EMP-LAST-NAME-0415 2 _ _ _ X START-YEAR-0415 5 _ _ _ X START-MONTH-0415 3 _ _ _ X START-DAY-0415 4 _ _ _ EMPOSITION X SALARY-GRADE-0420 6 1 A 1 X SALARY-AMOUNT-0420 7 _ _ _ X BONUS-PERCENT-0420 8 _ _ _ Display lines: Detail and/or Summary X Group by all _ Compute: 1=HELP 3=QUIT 4=MESSAGE 5=DISPLAY 6=MENU 8=FWD 11=HEADER
Type qfile in the command line to proceed to the Qfile Processing screen.
CA OLQ Release nn.n *** Display Report *** -> qfile Page 1 Line 1 133015 Default SUMMARY report columns selected 125000 Press the ENTER key to go to the next page of the report. EMPLOYEE/EMPOSITION REPORT mm/dd/yy SAL. GRADE AMOUNT ───── ────────────────────── 11 AVE FOR 11: 13166.66 12 AVE FOR 12: 14125.00 13 AVE FOR 13: 14875.00 21 AVE FOR 21: 18583.33 22 AVE FOR 22: 22500.00 33 AVE FOR 33: 38166.66 - 1 - 1=HELP 3=QUIT 4=MESSAGE 6=MENU 8=FWD 10=LEFT 11=RIGHT
|
Copyright © 2013 CA.
All rights reserved.
|
|