Previous Topic

Next Topic

Book Contents

Book Index

Defining the Paste

A column range is pasted by typing its identifier in the Paste line column where you want the column range to begin.

  1. Set the cursor in the first column of the Paste line.
  2. Using the SPACEBAR, type in the identifiers as labeled below.

    Figure 75 Pasting a Column Range

    THE ORIGINAL LINE

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

    EMPLOYEE     EMPLOYEE     OFFICE  ANNUAL  SOCIAL        NO. OF      JOB CLASS

          

    Use the following 5 lines to Cut & Paste, Color and Freeze columns

    CUT   :

    A-----------EB-----------EC------E        D----------E

    PASTE :

    A            B            F          C       D

  3. Press Enter

    The changes you made appear in "The Resulting Line," as shown below.

    Figure 76 After Pasting a Column Range

    THE RESULTING LINE

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

    EMPLOYEE     EMPLOYEE     INSURANCE  OFFICE  SOCIAL

    Note the following about the paste you just performed:

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

    Figure 77 Report Viewing Screen after Cut and Paste

    ------------- 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

      66114    S. MCCLURE         220.00    02     XXX-YY-ZZZZ

      66115    N. TRACEY          120.00    08     XXX-YY-ZZZZ

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

The fields are now arranged in the desired order, and the report is now narrow enough so that you no longer need to shift to the right or left to see all the required data. By not applying your edits to line 001, you have enabled the report title to appear in its original format.

Parent Topic

Reformatting Report Columns