Previous Topic: Edit PRINT StatementNext Topic: Move Lines

Using CREATE in DQL Mode › Creating the Sample Query › Step 6: Print or Display Report Data › Arrange Column Order

Arrange Column Order

To arrange the columns selected in the order wanted, follow these steps:

  1. Type 1 in the space before CUST-ID.
  2. Type 2 in the space before ITM-ID.
  3. Type 3 in the space before SHIP-QTY.
  4. Type 4 in the space before UNIT-PRICE.
  5. Press <PF2> RETURN to return to the CREATE MODE panel.

To select columns for the report and to specify their order, you place an order number in the space before the column name. In this example, it so happens the columns are included in the table in the order they were selected for the report. (You could place a 1 before UNIT-PRICE and a 4 before CUST-ID if you wanted them to appear in that sequence in the report.) When selections are complete, pressing <PF2> returns to the CREATE MODE panel where the selections have been inserted as shown in the following panel.

Result

 =>

 --------------------------------------------------------------------------DQD10
 DATAQUERY:  EDITOR            CURRENT TABLE:  CAI-DETAIL-TBL
 -------------------------------------------------------------------------------
 NAME:          USER-SAMPLE                       TYPE: QUERY   STATUS: PRIVATE
 DESCRIPTION:   TOTAL ORDERS PER CUSTOMER -- AVERAGE PRICE
    ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+.
 .. ================================ T O P =====================================
 01  FIND ALL  CAI-DETAIL-TBL ROWS
 02       WITH SHIP-QTY GT 0
 03  SET SHIP-PRICE(7.2) = UNIT-PRICE * SHIP-QTY
 04  SORT BY (CUST-ID)
 05  PRINT FROM TITLE1 'FILLED CUSTOMER ORDERS'
 06         (SHIP-PRICE) PICTURE 'Z,ZZZ,ZZ9.99-'
 07  CUST-ID
 08  ITM-ID
 09  SHIP-QTY
 10  UNIT-PRICE
 .. ===========================  B O T T O M  ==================================
 -------------------------------------------------------------------------------
 <PF1> HELP        <PF2>  RETURN     <PF3> DISPLAY COLUMNS <PF4> DISPLAY KEYS
 <PF5> DISPLAY ALL <PF6>  LIST TABLES<PF7> BACKWARD        <PF8> FORWARD
 <PF9> TEMPLATE    <PF10> VALIDATE   <PF11> RIGHT/LEFT     <PF12>PROCESS MODE