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”)