Using QMF

Changing the order in which columns are displayed

You can change the order in which the columns are displayed in your report by changing the sequence, or SEQ, field for that column.

For this example, you want to change the order of the columns to DEPT, JOB, NAME, SALARY, COMM, and TOTAL EARNINGS.

To change column order:

1. Type the new sequence number over the existing one.

   In this example, type the following:

   • 3 for the NAME sequence number
   • 1 for the DEPT sequence number
   • 2 for the JOB sequence number
   • 6 for the TOTAL_EARNINGS sequence number

   Figure 82. Change the order of columns by changing the SEQ field.
   

   +--------------------------------------------------------------------------------+
   |FORM.COLUMNS                                         MODIFIED                   |
   |                                                                                |
   |                        Total Width of Report Columns: 62                       |
   |  NUM COLUMN HEADING                           USAGE   INDENT WIDTH EDIT  SEQ   |
   |  --- ---------------------------------------- ------- ------ ----- ----- ---   |
   |    1 NAME                                             2      9     C     3     |
   |    2 DEPT                                             2      6     L     1     |
   |    3 JOB                                              2      5     C     2     |
   |    4 SALARY                                           2      10    L2    4     |
   |    5 COMM                                             2      10    L2    5     |
   |    6 TOTAL_EARNINGS                                   2      10    C     6     |
   |      *** END ***                                                               |
   +--------------------------------------------------------------------------------+

2. Press the Report function key to see the changed report.

   Figure 83. The changed report shows the columns in a new order.
   

   +--------------------------------------------------------------------------------+
   |                                                      TOTAL                     |
   |     DEPT  JOB    NAME           SALARY        COMM  EARNINGS                   |
   |   ------  -----  ---------  ----------  ----------  ----------                 |
   |       15  CLERK  KERMISCH     12258.50      110.10  12368.60                   |
   |       15  CLERK  NGAN         12508.20      206.60  12714.80                   |
   |       15  SALES  ROTHMAN      16502.83     1152.00  17654.83                   |
   |       20  CLERK  JAMES        13504.60      128.20  13632.80                   |
   |       20  SALES  PERNAL       18171.25      612.45  18783.70                   |
   |       20  CLERK  SNEIDER      14252.75      126.50  14379.25                   |
   |       38  CLERK  ABRAHAMS     12009.75      236.50  12246.25                   |
   |       38  CLERK  NAUGHTON     12954.75      180.00  13134.75                   |
   |       38  SALES  O'BRIEN      18006.00      846.55  18852.55                   |
   |       38  SALES  QUIGLEY      16808.30      650.25  17458.55                   |
   +--------------------------------------------------------------------------------+