In the Select Data Sort Order dialog box, you can select an ascending or descending sort order for the data in a column. Sort order determines the order in which rows are displayed in the drill-through report. For example, you can sort the contents of the Time.TRANSDATE column, which represents the transaction dates, in ascending order in the drill-through report.
To define the sort order of rows in the drill-through report:
In the Available Columns list, select the Time.TRANSDATE column.
The columns in the Available Columns list box are those that you selected in Lesson: Selecting and Ordering Columns. The columns in the Column list are those for which a sort order is defined in Integration Services Console.
If a data sort order was selected when the report was created in Integration Services Console, the Order By list displays that selection. Otherwise, the default sort order is Ascending.
Click
to move the Time.TRANSDATE column to the Column list , so that you can define a sort order for the column.In the Column list, double-click the Time.TRANSDATE column to change the data sort order from Ascending to Descending.
This action causes transaction date values to be displayed in reverse chronological order in the drill-through report.
Click Next to display Select Data Filters, and follow the steps in Lesson: Filtering Data to customize the report further.