Change the order in which the columns are displayed in
your report by changing the sequence, or SEQ,
field for that column.
Procedure
For this example, you change the order of the columns
to DEPT, JOB, NAME, SALARY, COMM, and TOTAL EARNINGS:
- Type the new sequence number over the existing number for
each column.
In this example, type the following:
- 3 for the NAME sequence number
- 1 for the DEPT sequence number
- 2 for the JOB sequence number
The following figure shows the SEQ column with the new
order.
Figure 1. 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 ***
- Press the Report function key to see the changed report,
which is shown in the following figure.
Figure 2. The changed report
shows the columns in their 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