In this exercise you will design a report where the records of employees with an annual salary of 40,000 or more are prominently displayed without having to read through the entire report.
To do this, you can use a ruler to request that such records appear in a specific color (and/or with a special highlight) when viewed online.
Annual salary appears in columns 36 through 41.
Figure 40 Determining Columns for Coloring and/or Highlighting
------------- CONTROL-D/V REPORT VIEWING NOTES 0 PAGE 1 OF 3
COMMAND ===> SCROLL ===> CRSR
USR DEMO REP EMPLOYEES-MARKETING JB JDEMO 04544 DT 050500 RUL DEFAULT
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
1 E M P L O Y E E S R E P O R T ----- FOR MARKETING DEPAR
EMPLOYEE EMPLOYEE OFFICE ANNUAL SOCIAL NO. OF JOB CLASS
NO. NAME NO. SAL SECURITY NO. DEPENDENTS CODE
-------- -------------- ------ ------ ------------ ---------- ---------
66002 A. HABER 07 31,000 XXX-YY-ZZZZ 2
Figure 41 Report Editing Screen Before Selecting Color Option
------------------------ CONTROL-D - REPORT EDITING --------------------(U.E)
COMMAND/OPT ===>
USER DEMO REPORT EMPLOYEES-MARKETING JOB JDEMO
RULER NAME ===> DEFAULT Name or blank for default ruler
RULER TYPE ===> VIEW View or Print
REPORT NAME ===> To copy a ruler - full report name
JOB NAME ===> To copy a ruler - full job name
USER NAME ===> To copy a ruler - full user name
1 EDIT report lines and columns
2 INCLUDE lines based on strings
3 EXCLUDE lines based on strings
4 COLOR lines based on strings
PLEASE SELECT OPTION, OR PRESS PF3 TO SAVE/EXIT THE RULER 16.46.36
The RULER NAME and RULER TYPE fields specify the current ruler (DEFAULT and VIEW).
When you defined the report Header lines and froze columns, you selected Option 1 on the Report Editing screen. Now select Option 4: COLOR lines based on strings.
The Color Lines Based on Strings screen is displayed.
Note: If you are not working on a color monitor and want to skip this exercise, press the END key (PF03/PF15) twice and proceed to Saving With Or Without Overwriting an Existing Ruler.
Parent Topic |