Defining Color Based on Strings

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.

1. First, use the Column Numbering line in the Report Viewing screen to determine the column numbers of the ANNUAL SAL field.

   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

2. To request that records for employees with an annual salary of 40,000 or more appear in reverse highlight, in red, do the following:
   1. Press the QUICKVIEW key (PF04/PF16). The Report Editing screen is displayed.

   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.

   1. Type 4 in the COMMAND field and press Enter.

      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.