Line Range Field

1. Before checking the results of the freeze operation, look at the two LINES fields at the far right of the second line of the screen. These fields specify a report line range (to and from) to which indicated operations are to be applied.

   Figure 31 Looking at Lines in Edit Report Columns Screen

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

   COMMAND ===>                                                    LINES 001 - 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   :

   The displayed default LINES values 001 – L01 apply the following freeze operations to the entire report:

   Table 4 Default LINES Values and Freeze Operation Results

   Value	Description
   001	In the LINES from field. The freeze operation is applied from line 1 (that is, from the first line) of each report page.
   L01	In the LINES to field. The L indicates that counting begins from the last line of each report page. The operation is applied through the last line of the report.

2. Check the result of this freeze operation, as follows:
   1. Press the QUICKVIEW key (PF04/PF16). The Report Viewing screen is displayed.
   2. Press the RIGHT key (PF11/PF23).

   Figure 32 Frozen Fields in Report Viewing Screen

   ------------- 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            E M P L O Y E TMENT       DATE:  03/05/00

   EMPLOYEE     EMPLOYEE     UNION   INSURANCE  SICK  VAC

       NO.         NAME       DUES               DAYS  DAYS

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

     66002    A. HABER        116.00     212.00   01    02

     66019    K. HARARI       150.00     068.00   01    07

     66043    K. TURRO        100.00     112.00   01    10

     66045    W. MAY          156.00     114.00   01    06

     66047    A. FELSEN       154.00     222.00   01    07

     66050    T. HUBERTY      157.00     222.00   01    07

     66052    K. WOOD         158.00     292.00   01    07

     66056    H. RUNDLE       153.00     219.00   01    07

     66059    L. WEST         107.00     222.00   05    05

     66078    N. LAMBERT      075.00     200.00   01    00

     66093    J. SHARPTON     106.00     222.00   01    03

     66112    K. BENNETT      123.00     120.00   01    07

     66113    T. OGURA        122.00     220.00   01    07

     66114    S. MCCLURE      120.00     220.00   01    07

     66115    N. TRACEY       120.00     120.00   01    07

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

   The EMPLOYEE NO. and EMPLOYEE NAME fields remain in position, and the rest of the screen display shifts right.

   It is now easy to see which insurance premium belongs to K. Wood.

   Note, however, what happened to the report title. The specified columns in the title were frozen, but the rest of the title shifted, making the title unclear.

   In the next exercise, you will freeze all displayed columns in the title line so that the title does not shift.