How to Format Your Report › Editing Your Report Values

Editing Your Report Values

In this example, you use the Report Format - Edit screen to:

• Suppress the display of repeating values in a given column
• Align the data under a column header (left-justified, center, right-justified)
• Change the order in which your columns are displayed

     CA OLQ Release nn.n                       *** Report Format - Edit ***
 ->                                                       Page     1 of     1
135000 Specify edit options and press the ENTER key.

                                       Disp                     Code        Disp
                                       Seq Sparse Hex  Align    Table   Ver Len
   DEPARTMENT
 X  DEPT-ID-0410                         1    _    _    RIGHT
   EMPLOYEE
 X  EMP-LAST-NAME-0415                   2    _    _    LEFT
   EMPOSITION
 X  SALARY-AMOUNT-0420                   3    _    _    RIGHT









 Compute:

 1=HELP   3=QUIT   4=MESSAGE   5=DISPLAY   6=MENU   10=HEADER   11=PICTURE

Start on the Report Format - Edit screen. To get there, type EDIT in the command line of any screen and press [Enter].

Suppressing repeating values

When a column displays the same value for many consecutive rows, the report can become hard to read. To suppress repeating values in a column, use the Sparse option on the Report Format - Edit screen:

If you don't use Sparse:        If you use Sparse:

DEPT   EMPLOYEE   PHONE         DEPT   EMPLOYEE   PHONE
----   ────────   ─────         ────   ────────   ─────
 003   Sam        1250           003   Sam        1250
 003   Elmer      3000                 Elmer      3000
 003   Leo        4110                 Leo        4110
 005   Jack       3092           005   Jack       3092
 005   Gus        5555                 Gus        5555

To restore a column to full display, type a space under Sparse next to that column.

Sparse/Full

Another way to suppress repeating values is to use the Sparse and Full options on the Session Options screen.

• Sparse displays only the first of a repeating set of column values.
• Full displays all occurrences of the repeating value.

To get to the Session Options screen, type OPTIONS in the command line and press [Enter].

Note: When you select the sparse option on the Report Format - Edit screen, the display of repeating values is suppressed only for the column you specify.

When you specify the Sparse/Full option on the Session Options screen, the display of repeating values is suppressed throughout the entire report.

Aligning columns

You can modify how the columns of data align under their headers by using the Align field. For example:

Using LEFT:         Using CENTER:       Using RIGHT:

BONUS-PERCENT       BONUS-PERCENT       BONUS-PERCENT
--------------      ──────────────      ──────────────
03                       03                         03
02                       02                         02
06                       06                         06

To specify how you want data to align under the column headings, type LEFT, CENTER, or RIGHT under Align next to that column.

Changing the column order

Use the Display Sequence field to specify the order in which columns are to appear. For each column, type a number to indicate the new position for that column. For example:

                      Disp
                      Seq
NAME                  3
ID                    1
PHONE                 2
SALARY                4