Introduction

In Chapter 2, you were introduced to the use of rulers in online viewing. This chapter demonstrates additional ruler capabilities. In this chapter you will:

• Observe the advantages provided by column reformatting
• Use the Edit Report Columns screen to reformat report columns by defining a "cut and paste" operation
• Use the Edit Report Lines and Columns screen to make your report easier to read by adding Overlay lines
• Use the Exclude screen to exclude undesired records from your report
• Learn to use the Apply on Header field in certain editing screens
• Use the Color Lines Based on Strings screen to specify color and highlight attributes for the report
• Use the Edit Report Lines and Columns screen to define Dynamic Extraction parameters that copy information from one location to another within your report
• Delete unnecessary report lines
• Define a Print ruler to reformat a report for printing.
• Learn to use Global rulers
• Learn to use SHOWCC and SHOWPAGE commands

1. Re-enter the Online Viewing facility and learn more about editing reports.
2. Enter the Control-D Online Viewing facility and display the entry panel.
3. Type DEMO in the USER field and press Enter.

   The Active User Report List screen is displayed.

   Figure 67 Active User Report List Screen (Unedited)

   ACTIVE LIST    <D> JOB          REP                      USR DEMO           (U)

   COMMAND ===>                                                    SCROLL===> CRSR

   O USER     REPORT               ODATE     PAGES    LINES V N STATUS

     DEMO     INVENTORY REPORT     05/05/00      9      427 V   Decollated

     DEMO     EMPLOYEES-MANAGMENT  05/05/00      1       18     Decollated

     DEMO     EMPLOYEES-MARKETING  05/05/00      3      131     Decollated

     DEMO     EMPLOYEES-DEVELOPMEN 05/05/00      1       10     Decollated

     DEMO     EMPLOYEES-PRODUCTION 05/05/00      3      169     Decollated

     DEMO     BANKING REPORT       05/05/00      5      256     Decollated

   ====== >>>>>>>>>>>>>>>   B O T T O M    O F    L I S T   <<<<<<<<<<<<<<< ======

      

      

      

      

      

      

      

      

      

      

      

      

   P PRINT     V VIEW     U UPDATE     I INSERT     A ADD INFO     E EDIT        

   X INDEX     N NOTE     G GIVETO     D DELETE     Q QUICK ACCESS       10.24.32

4. Type V (View) in the OPTION field of the EMPLOYEES-MARKETING report, and press Enter.

   The Report Viewing screen is displayed.

   Figure 68 Report Viewing Screen Before Editing

   ------------- CONTROL-D/V REPORT VIEWING   NOTES    1   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

     66019    K. HARARI         16    35,500   XXX-YY-ZZZZ      3

     66043    K. TURRO          02    29,000   XXX-YY-ZZZZ      1

     66045    W. MAY            04    35,000   XXX-YY-ZZZZ      4

     66047    A. FELSEN         08    27,500   XXX-YY-ZZZZ      2

     66050    T. HUBERTY        08    27,500   XXX-YY-ZZZZ      2

     66052    K. WOOD           08    26,000   XXX-YY-ZZZZ      2

     66056    H. RUNDLE         08    26,000   XXX-YY-ZZZZ      2

     66059    L. WEST           26    38,000   XXX-YY-ZZZZ      2

     66078    N. LAMBERT        18    29,000   XXX-YY-ZZZZ      3

     66093    J. SHARPTON       09    29,000   XXX-YY-ZZZZ      3

     66112    K. BENNETT        04    29,000   XXX-YY-ZZZZ      3

     66113    T. OGURA          03    28,000   XXX-YY-ZZZZ      4

     66114    S. MCCLURE        02    37,500   XXX-YY-ZZZZ      2

     66115    N. TRACEY         08    23,000   XXX-YY-ZZZZ      1

   CMDS: FIND str (PREV), EDIT, RULER on/off/name, VALUE, N n P n        08.16.47

Note: The report is displayed using the DEFAULT ruler. When a report is requested for viewing, the report is displayed with its DEFAULT ruler if one has been defined.