Order By Clauses

This page will provide a description and examples for each Basic Comparison Operator that are made available in Report Builder

Overview

Organising the columns (data or information) in your report will make it more meaningful and easy to interpret. In Report Builder, you have the option to order your columns into groups by specifying the order in the Order By Clauses section. Order by clauses will let you format the columns (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, and dates and times order from oldest to newest.

Example

Start Date Column set as Ascending order in the Report Output

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

Sample Report Output Start Date column ordered in Ascending

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, and dates and times order from newest to oldest.

Example

Start Date Column set as Descending order in the Report Output

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

Sample Report Output Start Date column ordered in Descending

You can also set the order directly on the Output File that you have chosen. For example, in Excel -you can use the Sort and Filter feature. If you chose Print Format HTML, selecting the column header will help you with the ordering of your data.

Clicking the Start Date Header can order the result into Ascending or Descending