In the Select Data Sort Order dialog box, you can select a column and specify its sort order for the drill-through report.
Report Name—Displays the name of the drill-through report that you are customizing.
Available Columns—Displays the columns that you select in the Select Columns and Display Order dialog box. Select a column from this list box and move it to the Column list box to select a sort order for the column.
Right Arrow—Click to move a selected column to the list box on the right.
Left Arrow—Click to move a selected column back to the list box on the left.
Right Double Arrow—Click to move all columns to the list box on the right.
Left Double Arrow—Click to move all columns back to the list box on the left.
Column—Double-click columns to change the data sort order from Ascending to Descending, or Descending to Ascending.
Order By—Displays the data sort order for each column, as defined in Integration Services Console. Otherwise, the default sort order is Ascending. Double-click the column name to change the sort order.
Move Up—Click to move a column up in the list box.
Move Down—Click to move a column down in the list box.
Order By—Click to select a data sort order for several columns simultaneously after selecting multiple columns from the Column list box.
Back—Click to move to the previous screen of the Drill-Through Wizard.
Next—Click to move to the next screen of the Drill-Through Wizard.
Finish—Click to generate a drill-through report and display the results in the spreadsheet.