Dynamic Extraction Parameters

Headers designed for print reports often do not allow you to view more than a few lines of data online when viewing the report online.

For example, since the headers of the current report occupy eleven lines, only eight lines of data can be displayed in each screen. Condensing information from many Header lines into one line would help solve this problem.

Figure 100 Report Viewing Screen before Condensing Header Lines

------------- CONTROL-D/V REPORT VIEWING NOTES 0 PAGE 1 OF 9

COMMAND ===> SCROLL ===> CRSR

USR DEMO REP INVENTORY REPORT JB JDEMO 04544 DT 050500 RUL DEFAULT

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

1DATE: 03.05.00

UPDATE: 03.05.00

INVENTORY REPORT

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

WAREHOUSE NO: 1001 DEPARTMENT: 100 - FINAL ASSEMBLY SHOP

SHELF QNTY QNTY QNTY QNTY IN

ITEM NO. DESCRIPTION LIFE UNIT AVAIL ORDER PROCESS

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

1233-781-21 RIVET D. 0.1 ACR NONE KG 100.00 250.00

1233-781-25 RIVET D. 0.5 ACR NONE KG 500.00 500.00

1233-781-27 RIVET D. 0.7 ACR NONE KG 100.00 100.00

2200-700-22 RUBBER RING D. 2.2 1 MON EA 10.00 10.00

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

You have already seen that overlay lines can be used to insert lines of text in the report. If header line information never changes, you can type header information in a single overlay line, as follows:

INVENTORY REPORT - WRHS: 1001 DEPT: 100 DTE: 05.05.00 UPD: 05.05.00

You can then delete the unnecessary header lines.

However, header line information is usually dynamic (that is, it does change). For example, the Department number (in the header line) may be 100 on report page 1, and 101 on report page 2. In this case, typing fixed text in an overlay line in the Edit Report Lines and Columns screen is not sufficient.

Special dynamic extraction parameters can be defined in the overlay line to extract variable information from specified report lines. When the overlay lines are inserted into the report display, the extracted information appears in place of the parameters (for example, 100 on page 1 and 101 on page 2).

The following steps will return you to the Edit Report Lines and Columns screen, where you can define dynamic extraction parameters to condense our header line information.

Press the QUICKVIEW key (PF04/PF16) to display the Color Lines Based on Strings screen.
Press the END key (PF03/PF15) to display the Report Editing screen.
Choose Option 1 and press Enter to display the Edit Report Lines and Columns screen.
Dynamic Extraction parameters require a special identifying character (of your choice) that you specify in the SP CHAR field on the command line of the Edit Report Lines and Columns screen. For this exercise, you will use the % character for the identifying character.
Type % in the SP CHAR field and press Enter.

Figure 101 Use of the % Character in SP CHAR Field

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

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

USR DEMO     REP INVENTORY REPORT     JB JDEMO    RULER DEFAULT   TYPE VIEW

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

H 1DATE:   05.05.00

H  UPDATE: 05.05.00

H                                   INVENTORY REPORT

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

H

H  WAREHOUSE NO: 1001       DEPARTMENT:  100  -  FINAL ASSEMBLY SHOP

I                ----                    ---------------------------

H

H                                     SHELF   QNTY   QNTY       QNTY       QNTY

H  ITEM NO.      DESCRIPTION          LIFE    UNIT   AVAIL      ORDER      PROC

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



    1233-781-21   RIVET D. 0.1 ACR     NONE    KG      100.00     250.00
Type I (Insert) in the OPTION field of the line containing the warehouse and department number underlines (as shown in below) and press Enter. This will insert an overlay line in which you can define the dynamic extraction parameters.
Figure 102 Inserting a Line for Dynamic Extraction Parameters

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

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

USR DEMO     REP INVENTORY REPORT     JB JDEMO    RULER DEFAULT   TYPE VIEW

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

H 1DATE:   05.05.00

H  UPDATE: 05.05.00

H                                   INVENTORY REPORT

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

H

H  WAREHOUSE NO: 1001       DEPARTMENT:  100  -  FINAL ASSEMBLY SHOP

I                ----                    ---------------------------

H

H                                     SHELF   QNTY   QNTY       QNTY       QNTY

H  ITEM NO.      DESCRIPTION          LIFE    UNIT   AVAIL      ORDER      PROC

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

An overlay line is inserted below the line containing the underlines.

Figure 103 Overlay Line Inserted

H  WAREHOUSE NO: 1001       DEPARTMENT:  100  -  FINAL ASSEMBLY SHOP

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

O

H

H                                     SHELF   QNTY   QNTY       QNTY       QNTY

H  ITEM NO.      DESCRIPTION          LIFE    UNIT   AVAIL      ORDER      PROC

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

Dynamic extraction parameters determine what report data are to be extracted from the report as originally formatted. Column placement of these parameters in the overlay lines determines where the data will appear in the inserted report lines when the report is reformatted.

Parent Topic

Advanced Report Editing (Ruler Capabilities)