# Order By Clauses

## Overview <a href="#overview" id="overview"></a>

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 <a href="#ascending" id="ascending"></a>

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 &#x5A;**,** and dates and times order from oldest to newest.

**Example**

<figure><img src="/files/F19AQ8lgWbh0GFVwRU8T" alt=""><figcaption><p>Start Date Column set as Ascending order in the Report Output</p></figcaption></figure>

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

<figure><img src="/files/9Rn8WEOlNhe7wYDC2TMb" alt=""><figcaption><p>Sample Report Output Start Date column ordered in Ascending</p></figcaption></figure>

## Descending <a href="#descending" id="descending"></a>

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**

<figure><img src="/files/rlICPH0Roy5dkaerMVP8" alt=""><figcaption><p>Start Date Column set as Descending order in the Report Output</p></figcaption></figure>

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

<figure><img src="/files/zp7JmYAohYSqIkOBh3pe" alt=""><figcaption><p>Sample Report Output Start Date column ordered in Descending</p></figcaption></figure>

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.

<figure><img src="/files/QXES7AvzqoGwsxoLCNUl" alt=""><figcaption><p>Clicking the Start Date Header can order the result into Ascending or Descending</p></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.silverband.com.au/home/paradigm-knowledge-base/generating-reports/workflows/advanced-report-builder/order-by-clauses.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.