Run Report Order
A Run Report Order is used in a Run Report Function to provide a sort order to the data. These can be created in the Insert Run Report function wizard, or they can be created manually.
There are two parameters in the function.
| Parameter | Description |
|---|---|
| Sort Order | Ascending (ASC) or Descending (DESC) |
| Field | The name of the field or fields returned in the SQL. If multiple field names are specified they should be separated by a comma. |
Example: =RW_Run_Report_Order(“ASC”,”Invoice Number”)
Sorting on multiple fields example: =RW_Run_Report_Order(“DESC”,”Operating Unit Name,Invoice Number”)