4D v13.4
QR SET SORTS
- 4D Language Reference
-
- Quick Report
-
- QR BLOB TO REPORT
- QR Count columns
- QR DELETE COLUMN
- QR DELETE OFFSCREEN AREA
- QR EXECUTE COMMAND
- QR Find column
- QR Get area property
- QR GET BORDERS
- QR Get command status
- QR GET DESTINATION
- QR Get document property
- QR Get drop column
- QR GET HEADER AND FOOTER
- QR Get HTML template
- QR GET INFO COLUMN
- QR Get info row
- QR Get report kind
- QR Get report table
- QR GET SELECTION
- QR GET SORTS
- QR Get text property
- QR GET TOTALS DATA
- QR GET TOTALS SPACING
- QR INSERT COLUMN
- QR New offscreen area
- QR ON COMMAND
- QR REPORT
- QR REPORT TO BLOB
- QR RUN
- QR SET AREA PROPERTY
- QR SET BORDERS
- QR SET DESTINATION
- QR SET DOCUMENT PROPERTY
- QR SET HEADER AND FOOTER
- QR SET HTML TEMPLATE
- QR SET INFO COLUMN
- QR SET INFO ROW
- QR SET REPORT KIND
- QR SET REPORT TABLE
- QR SET SELECTION
- QR SET SORTS
- QR SET TEXT PROPERTY
- QR SET TOTALS DATA
- QR SET TOTALS SPACING
QR SET SORTS
| QR SET SORTS ( area ; aColumns {; aOrders} ) | ||||||||
| Parameter | Type | Description | ||||||
| area | Longint |
|
Reference of the area | |||||
| aColumns | Real array |
|
Columns | |||||
| aOrders | Real array |
|
Sort orders | |||||
The QR SET SORTS command sets 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} is 1, the sort order is ascending.
- If aOrders{$i} is -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.
Product: 4D
Theme: Quick Report
Number:
752
Created: 4D 2003
