Your qfile definition saves all of the formatting enhancements you have included in your report. Enhancements include sorts, break processing, external pictures, headings, and report titles.
See Chapter 5, "How to Format Your Report" for more information on how to format your report.
In this step, you enhance your qfile definition by:
Start on the Report Format - Sort screen. To get there, type sort on the command line of any screen.
To sort the rows by salary grade, specify 1 in the Sort Priority column next to SALARY-GRADE-0420. Specify a (for ascending) in the Order (A/D) column next to SALARY-GRADE-0420.
To group you report rows by salary grade, specify 1 in the Group By Level # column next to SALARY-GRADE-0420.
CA OLQ Release nn.n *** Report Format - Sort *** -> Page 1 of 1 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 3 _ _ _ X START-MONTH-0415 4 _ _ _ X START-DAY-0415 5 _ _ _ EMPOSITION X SALARY-GRADE-0420 6 1 a 1 X SALARY-AMOUNT-0420 7 _ _ _ X BONUS-PERCENT-0420 8 _ _ _ Display lines: Detail X and/or Summary X Group by all _ Compute: 1=HELP 3=QUIT 4=MESSAGE 5=DISPLAY 6=MENU 11=HEADER
Type header on the command line.
CA OLQ Release nn.n *** Report Format - Group By *** -> header Page 1 OF 1 136000 Specify summary computations and press the ENTER key Group by COLUMN: SALARY-GRADE-0420 Level# 1 Seq Total Avg Hival Loval Count _ EMPLOYEE X EMP-FIRST-NAME-0415 1 _ _ _ _ X EMP-LAST-NAME-0415 2 _ _ _ _ X START-YEAR-0415 3 _ _ _ _ X START-MONTH-0415 4 _ _ _ _ X START-DAY-0415 5 _ _ _ _ EMPOSITION X SALARY-GRADE-0420 6 _ _ _ _ X SALARY-AMOUNT-0420 7 _ x _ _ X BONUS-PERCENT-0420 8 _ _ _ _ Skip lines after group 1 Separator character - Compute: 1=HELP 3=QUIT 4=MESSAGE 5=DISPLAY 6=MENU 10=PICTURE
Change the display of the date columns to list them in order of month, day, and year. Change your headers to make them more legible.
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-FIRST-NAME-0415 1 First Name X EMP-LAST-NAME-0415 2 Last Name X START-YEAR-0415 5 ' ' X START-MONTH-0415 3 Start X START-DAY-0415 4 ' ' EMPOSITION X SALARY-GRADE-0420 6 Grade X SALARY-AMOUNT-0420 7 Salary Amount X BONUS-PERCENT-0420 8 Bonus % Compute: 1=HELP 3=QUIT 4=MESSAGE 5=DISPLAY 6=MENU 8=FWD 10=SORT 11=EDIT
CA OLQ Release nn.n *** Display Report *** -> Page 1 Line 1 105022 Sort successfully completed. 68 records in. 68 records out. 125000 Press the ENTER key to go to the next page of the report. EMPLOYEE/EMPOSITION REPORT mm/dd/yy FIRST LAST SALARY BONUS NAME NAME START GRADE AMOUNT % ────────── ─────────────── ───── ── ── ───── ────────────────────── ───── TOM FITZHUGH 09 19 81 11 13000.00 .004 NANCY TERNER 05 26 82 11 13000.00 .004 CYNTHIA JOHNSON 03 23 77 11 13500.00 .004 ─────────── AVE FOR 11: 13166.66 ROBIN GARDNER 06 15 81 12 14000.00 .004 BRIAN NICEMAN 05 06 80 12 14000.00 .004 DORIS KING 08 16 80 12 14500.00 .004 SANDY KRAAMER 04 04 81 12 14000.00 .004 - 1 - 1=HELP 3=QUIT 4=MESSAGE 6=MENU 8=FWD 10=LEFT 11=RIGHT
|
Copyright © 2013 CA.
All rights reserved.
|
|