In this step of the wizard you can identify how the results from your query should be sorted by identifying one or more columns to sort.
Add Sort | Displays the Available Sort Columns window allowing you to select a column to sort by. | |
Remove Sort | Removes the selected column from the sort order. | |
Sort Ascending | Changes the sort direction of the selected column to sort values in ascending order. | |
Sort Descending | Changes the sort direction of the selected column to sort values in descending order. | |
Move Column Up | Moves the selected column higher in the list of sort columns. | |
Move Column Down | Moves the selected column lower in the list of sort columns. |
You can also affect the sort order by right-clicking on a column heading in the preview pane and using the sorting options that appear in the pop-up menu. Changes that you make to the sort order using this method will be reflected on this step.
Note - This step constructs the ORDER BY clause in the underlying SQL statement.