Sorting output items

You can use Sorting to specify the sort order of the output items. The sort order does not affect the display sequence of the output columns.

The order in which items are displayed in the Sorting dialog determines the sort order. The item that appears in the top row is sorted first, the item in the second row is sorted second, and so on. Items can be reordered by dragging them above or below other items.

On return to the data extraction dialog, the item sort order is indicated by the Sort Number, where 1 indicates an item is sorted first, 2 indicates an item is sorted second, and so on. An icon accompanying the Sort Number indicates whether an item is sorted in ascending (AZ) or descending (ZA) order.
Note: Sorting is only available for Summary Report and Detail Report queries.

To apply a sort order:

  1. Right-click any item and select Sorting.
  2. Order the output items into the correct sort order by dragging them above or below the other items.
  3. Double-click an item to modify the Sort Mode as none, ascending or descending. By default, items are set to None.
  4. Optionally, select an Output Option.
  5. Click OK.
Parent topic: Query Definition dialog