QR SET SORTS

version 2003

QR SET SORTS (area; aColumns{; aOrders})

The QR SET SORTS command allows you to set the sort orders for the columns in the report whose reference is passed in area.

aColumns: in this array, you need to store the column numbers of columns to which you want to assign a sort order.

aOrders: each element of this array must contain the sort orders for the matching column in the aColumns array.

• If aOrders{$i} equals 1, the sort order is ascending.

• If aOrders{$i} equals - 1, the sort order is descending.

In the case of cross-table mode, you cannot have more than two items in the array. You can only sort columns (1) and rows (2). The data (that are the intersection of columns and rows) cannot be sorted.

Here is the code to sort only the rows in the case of a cross-table report:

   ARRAY REAL($aColumns;1)
   $aColumns{1}:=2
   ARRAY REAL($aOrders;1)
   $aOrders{1}:=-1 `Alphabetic sort for rows
   QR SET SORTS (qr_area;$aColumns;$aOrders)

If you pass an invalid area number, the error -9850 will be generated.

QR GET SORTS.