Dynamic Order By

Dynamic Order By sorts report results based on parameters selected by a user. For example, you can set up Dynamic Order By to have a report that can be sorted by the Team, Pay Group, or Job columns. The user running the report selects which column data they would like to sort by and if they want to sort in ascending order or descending order. The report results are sorted based on the user's selections.

Two calculation columns must be added to the report results to Dynamic Order By. One column sorts the results in ascending order and the other sorts the results in descending order. In the results, the column corresponding with the selected sort order contains exact copies of the column data selected by the user. The data is sorted in the selected order.

To hide the ascending or descending columns in the report results, set the column Render property to No.