Applying Query Sorts

Sorting simplifies the process of data analysis. After data is sorted, the answers to questions are often readily at your fingertips because sorting ranks data to reveal trends and margins. If you apply simple sort conditions in the Query section, the database server sorts the data while refreshing the query before it is retrieved to your document file.

Typically, you can place an ascending or descending order on a sort condition that you place on a column.

  To apply a sort to the query, drag one or more items in the Request pane and drop them into the Sort pane.

Optional: A sort can also be applied by selecting an item and choosing Actions then Add to Sort.

When the query is refreshed, the request item is sorted in the results set.

  To sort in ascending order:

  1. Drag one or more items in the Request pane and drop them into the Sort Pane.

  2. Select Sort Ascending on the shortcut menu.

  To sort in descending order:

  1. Drag one or more items in the Request pane and drop them into the Sort pane.

  2. Select Sort Descending on the shortcut menu.

  To delete a sort, select the sort value to remove from Sort pane and choose Delete on the shortcut menu.

Deleting a sort returns the data to its original display.