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

Image Added

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)

Image Added

Descending

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

Example

Image Added

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)

Image Modified

_{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}