Selecting Data Sort Order

In the Select Data Sort Order dialog box, you can determine the order in which Integration Services displays the rows that it retrieves. For example, you can sort the contents of a REGION.DIRECTOR column in ascending order to present the regional directors in alphabetical order in the drill-through report.

  To define the sort order of rows in the drill-through report:

  1. Perform the tasks described in Selecting and Ordering Columns.

  2. In Available Columns, select the column for which you want to define a sort order.

    The columns in the Available Columns list box are those that you selected in Selecting and Ordering Columns.

    The columns in the Column list box are those for which a sort order is defined in Integration Services.

  3. Use the arrows to move columns to and from the right list box.

  4. To rearrange the display order of columns, select the column to rearrange in Column, and then click Move Up or Move Down.

  5. In Column, select a column for which you want to define the row order.

  6. Double-click the column to change the data sort order from Ascending to Descending (or conversely) to define whether the rows in the report are sorted in ascending or descending order.

    If a data sort order was selected when the report was created in Integration Services, that selection is displayed in the Order by list. Otherwise, the default sort order is ascending.

  7. To change the data sort order for multiple columns simultaneously, see Sorting Multiple Columns.

  8. When you finish arranging and sorting rows, perform an action:

    • Click Next and follow the steps in Selecting Data Filters to further customize the report.

    • Click Finish to generate the report and view the results in the spreadsheet.

    • Click Back.

Related Topics

Sorting Multiple Columns