How to Format Your Report › Sorting Your Report Rows › Step 1 - Sort your report

Step 1 - Sort your report

Start on the Report Format - Sort screen. To get there, type SORT in the command line.

Use Disp Seq to change the column order to reflect the sort priority. Use Sort Priority to specify that you want to sort the report rows by DEPT-ID (level 1), within each department by PROJECT (level 2), and within each project by SALARY-AMOUNT (level 3). Use Order (A/D) to specify that you want all of the sorts to be in ascending order. Press [PF5] to display your report.

      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 #
    EMPLOYEE
  X  EMP-LAST-NAME                           4         _        _          _
  X  DEPT-ID                                 1         1        a          _
  X  SALARY-AMOUNT                           3         3        a          _
  X  PROJECT                                 2         2        a          _









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

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