Previous Topic

Next Topic

Book Contents

Book Index

Inserting Overlay Lines

You can make the report easier to read by inserting a blank line after every five records in the report.

  1. Press the QUICKVIEW key (PF04/PF16) to display the Edit Report Columns.
  2. Press the END key (PF03/PF15) to display the Edit Report Lines and Columns screen.

    Figure 78 Edit Report LInes and Columns Screen (Unedited)

    -----------------  CONTROL-D - EDIT REPORT LINES AND COLUMNS  ----------(U.E.1)

    COMMAND ===>                                         SP CHAR    SCROLL===> CRSR

    USR DEMO     REP EMPLOYEES-MARKETING  JB JDEMO    RULER DEFAULT   TYPE VIEW

    O ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+--

    H 1            E M P L O Y E E S     R E P O R T    -----    FOR MARKETING   DE

    H  EMPLOYEE     EMPLOYEE     OFFICE  ANNUAL  SOCIAL        NO. OF      JOB CLAS

    H     NO.         NAME         NO.    SAL    SECURITY NO.  DEPENDENTS    CODE

    H  --------  --------------  ------  ------  ------------  ----------  --------

         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

    OPTIONS: H HEADER F FOOTER D DELETE C COLUMNS I INSERT B BEFORE        16.46.56

    Insertion of lines in your report is performed from the Edit Report Lines and Columns screen. Specifying I (Insert) in the OPTION field of a report line adds a blank line just below that report line. This blank line is called an Overlay line, and has an identifying character O in the OPTION field.

    The Edit Report Lines and Columns screen contains a copy of one full print-page (the current page) of your report. This page serves as a "model" for all pages in your report. As in the Report Viewing screen, this print page is longer than your screen display (and can be scrolled).

    To display a blank line after every five records in your report, you must insert an Overlay line after every five records in the entire report page (not just the current screen display) in the Edit Report Lines and Columns screen.

  3. Place an I (Insert) in the OPTION field of every fifth record of Page 1 of the report (Felsen, Lambert, Tracey and so on).

    Note: You must use the DOWN key (PF08/PF20) to scroll down each screen in Page 1. You can quickly return to the top of the page by typing M in the COMMAND field and pressing the UP key (PF07/PF19).

    Figure 79 Inserting Blank Lines

    -----------------  CONTROL-D - EDIT REPORT LINES AND COLUMNS  ----------(U.E.1)

    COMMAND ===>                                         SP CHAR    SCROLL===> CRSR

    USR DEMO     REP EMPLOYEES-MARKETING  JB JDEMO    RULER DEFAULT   TYPE VIEW

    O ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+--

    H 1            E M P L O Y E E S     R E P O R T    -----    FOR MARKETING   DE

    H  EMPLOYEE     EMPLOYEE     OFFICE  ANNUAL  SOCIAL        NO. OF      JOB CLAS

    H     NO.         NAME         NO.    SAL    SECURITY NO.  DEPENDENTS    CODE

    H  --------  --------------  ------  ------  ------------  ----------  --------

         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

    I   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

    I   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

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

    OPTIONS: H HEADER F FOOTER D DELETE C COLUMNS I INSERT B BEFORE        16.46.56

  4. Press Enter to complete insert requests. Overlay lines are inserted after each insert request.

    Note: You can press Enter after you type each I or after typing I any number of times. Whenever you press Enter, blank overlay lines, marked O, are inserted below each line previously marked I, and the I markers are removed.

    Figure 80 Effect of Inserting Blank Lines

    -----------------  CONTROL-D - EDIT REPORT LINES AND COLUMNS  ----------(U.E.1)

    COMMAND ===>                                         SP CHAR    SCROLL===> CRSR

    USR DEMO     REP EMPLOYEES-MARKETING  JB JDEMO    RULER DEFAULT   TYPE VIEW

    O ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+--

    H 1            E M P L O Y E E S     R E P O R T    -----    FOR MARKETING   DE

    H  EMPLOYEE     EMPLOYEE     OFFICE  ANNUAL  SOCIAL        NO. OF      JOB CLAS

    H     NO.         NAME         NO.    SAL    SECURITY NO.  DEPENDENTS    CODE

    H  --------  --------------  ------  ------  ------------  ----------  --------

         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

    O

         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

    O

         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

    OPTIONS: H HEADER F FOOTER D DELETE C COLUMNS I INSERT B BEFORE        16.46.56

    Note: If you make a mistake, you can delete unwanted overlay lines by typing D (Delete) in the OPTION field of the overlay line, and pressing Enter.

    Overlay lines can also be inserted in the Edit Lines screen using Option B (Before). Option B inserts an overlay line before the report line, whereas Option I inserts an overlay line after the report line.

  5. Press the QUICKVIEW key (PF04/PF16) to display the Report Viewing screen.

    The report is reformatted as shown in Figure 81.

    Figure 81 Reformatted Report Viewing Screen

    ------------- 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     INSURANCE  OFFICE  SOCIAL

        NO.         NAME                    NO.   SECURITY NO.

    --------  --------------  ---------  ------  ------------

      66002    A. HABER           212.00    07     XXX-YY-ZZZZ

      66019    K. HARARI          068.00    16     XXX-YY-ZZZZ

      66043    K. TURRO           112.00    02     XXX-YY-ZZZZ

      66045    W. MAY             114.00    04     XXX-YY-ZZZZ

      66047    A. FELSEN          222.00    08     XXX-YY-ZZZZ

         

      66050    T. HUBERTY         222.00    08     XXX-YY-ZZZZ

      66052    K. WOOD            292.00    08     XXX-YY-ZZZZ

      66056    H. RUNDLE          219.00    08     XXX-YY-ZZZZ

      66059    L. WEST            222.00    26     XXX-YY-ZZZZ

      66078    N. LAMBERT         200.00    18     XXX-YY-ZZZZ

         

      66093    J. SHARPTON        222.00    09     XXX-YY-ZZZZ

      66112    K. BENNETT         120.00    04     XXX-YY-ZZZZ

      66113    T. OGURA           220.00    03     XXX-YY-ZZZZ

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

  6. Type N in the COMMAND field and press Enter to view the next report page.

    Page 2 of the report also contains blank lines.

  7. Press the DOWN key (PF08/PF20).

    Blank lines are displayed as you scroll down the report.

  8. Type M (Max) in the COMMAND field and press the UP key (PF07/PF19) to display the top of the report.

Parent Topic

Advanced Report Editing (Ruler Capabilities)