Overview

Order by clauses will let you format the column (data or information) in your report output into Ascending or Descending order.

Ascending

When used for numerical fields or column names, numbers will be displayed in increasing order, that is, from smallest to largest, and when used for letters/words, the sort is alphabetical from A to Z.

Example

Sample Output (given the sample clause above, the start date will be ordered in ascending order in the output as shown in the screenshot below)

Descending

When used for numerical fields or column names, numbers will be displayed in decreasing order, that is, from largest to smallest, and when used for letters/words, the sort is from Z to A.

Example

Sample Output (given the sample clause above, the start date will be ordered in descending order in the output as shown in the screenshot below)

_{Advanced Report Builder | Order By Clauses | Alternative Data Formats | Bulk Student Select | Complex Filter Clause Operators | Nested Operators Using Brackets | User-Defined Parameters | Summarise Data | Generic Report Query}