Using QMF

Changing column widths and space between columns

In the report that is shown in Figure 85, the last letter of the COMMISSIONS column heading does not appear because the column is not wide enough. You can change the column width and the spacing between columns on the FORM.COLUMNS panel.

To change column width or spacing:

1. Move the cursor to the column whose width you want to change and type the new width under the WIDTH field. Be sure to include space for punctuation, such as dollar signs, commas, and decimal points.

   In this example, change the following:

   • 12 for the column width of the SALARY column.
   • 11 for the column width of the COMMISSIONS column.
   • 12 for the column width of the TOTAL_EARNINGS column.
2. To change the amount of space between columns of data, move the cursor to the column you want to move to the right. Then, type the new spacing under the INDENT field.

   For this example, type 4 for the spacing of the EMPLOYEE_NAME, JOB, and TOTAL_EARNINGS columns.

   Figure 86. Change the width and spacing of columns on FORM.COLUMNS.
   

   +--------------------------------------------------------------------------------+
   | FORM.COLUMNS                                           MODIFIED                |
   |                                                                                |
   |                        Total Width of Report Columns: 73                       |
   |  NUM COLUMN HEADING                           USAGE   INDENT WIDTH EDIT  SEQ   |
   |  --- ---------------------------------------- ------- ------ ----- ----- ---   |
   |    1 EMPLOYEE_NAME                                    4      9     C     3     |
   |    2 DEPT._NUMBER                                     2      6     L     1     |
   |    3 JOB                                              4      5     C     2     |
   |    4 SALARY                                           2      12    L2    4     |
   |    5 COMMISSIONS                                      2      11    L2    5     |
   |    6 TOTAL_EARNINGS                                   4      12    C     6     |
   |      *** END ***                                                               |
   |                                                                                |
   +--------------------------------------------------------------------------------+

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

   Figure 87. The changed report shows the new widths and spacing of columns.
   

   +--------------------------------------------------------------------------------+
   |   DEPT.              EMPLOYEE                                 TOTAL            |
   |   NUMBER    JOB        NAME           SALARY  COMMISSIONS    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          |
   +--------------------------------------------------------------------------------+