Previous Topic: Sorting Your Report RowsNext Topic: Step 2 - Display your report

How to Format Your Report › Sorting Your Report Rows › Step 1 - Specify your sort criteria

Step 1 - Specify your sort criteria

To sort the rows in ascending order by department ID, specify 1 in the Sort Priority column and a in the Order (A/D) column next to DEPT-ID-0410. And to sort each department's employees in ascending order by employee name, specify 2 in the Sort Priority column and an a in the Order (A/D) column next to EMP-LAST-NAME-0415.

      CA OLQ Release nn.n                           *** Report Format - Sort ***
  ->                                                       Page     1 of     1
 133000 Specify sort or group by request and press the ENTER key

                                            Disp      Sort    Order     Group By
                                            Seq     Priority  (A/D)      Level #
    DEPARTMENT
  X  DEPT-ID-0410                            1         1        a          _
    EMPLOYEE
  X  EMP-LAST-NAME-0415                      2         2        a          _
    EMPOSITION
  X  SALARY-AMOUNT-0420                      3         _        _          _








            Display lines:  Detail X  and/or  Summary X       Group by all _
  Compute:

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