Cutting and Pasting

Assume that you want to see only the following fields, in the following order:

The Edit Report Columns screen can be used to create a ruler that reformats the report in this way.

1. Press the QUICKVIEW key (PF04/PF16) to display the Report Editing screen.
2. Choose Option 1 (Edit Report Lines and Columns) and press Enter to display the Edit Report Lines and Columns screen.
3. As with column freezing, column reformatting requires that a model line be selected by typing C (Column) in the OPTION field.

Type C in the Header line as shown in the figure below, and press Enter.

Figure 69 Selected Fields in the Edit Report Lines and Columns Screen

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

C  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

The Edit Report Columns screen is displayed.

Figure 70 Edit Report Columns Screen (Previously Frozen)

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

COMMAND ===>                                                    LINES 002 - L01

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

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   :

PASTE :

COLOR :

HILITE:

FREEZE:

FFFFFFFFFFFFFFFFFFFFFFFFFFF

THE RESULTING LINE

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

  EMPLOYEE     EMPLOYEE     OFFICE  ANNUAL  SOCIAL        NO. OF      JOB CLASS

TO SHIFT, PLACE CRSR ON THE DESIRED LINE AND USE PF10-LEFT, PF11-RIGHT 16.47.13

The freeze edits that you specified in Chapter 2 are shown. The line range displayed is 002 – L01. Line 001 is not within the displayed range because you specified different freeze edits for line 001. Because you do not want your reformatting edits to be applied to the first line, you will not change this line range.

Column reformatting is done by means of a "cut and paste" operation performed in the Cut and Paste lines. The results may be seen under "The Resulting Line."

The first two fields in the ruler (Employee No. and Employee Name) were frozen by the Freezing Columns exercise in Chapter 2. They can be left frozen, or you can "unfreeze" them by erasing the Fs in the Freeze line. In either case, you must include these fields in the cut and paste if you want them to appear in the reformatted report.

You can now perform the cut and paste.

Note: When moving the cursor along the Cut and the Paste lines, you must use the SPACEBAR, not the RIGHT ARROW key.