You can determine the order in which the spreadsheet client displays the rows and the contents of the rows it retrieves; for example, you can sort the contents of the PRODUCTDIM.SKUNAME column in descending order (from highest to lowest value). This sort presents the products in reverse alphabetical order, from Vanilla Cream to Old Fashioned to Caffeine Free Cola.
If you do not specify the sort order, spreadsheet users view data in the order determined by the external data source. Microsoft SQL Server, for example, sorts members in ascending order by default.
Note: | This procedure is optional. |
To define the sort order of a drill-through column:
From the Report Contents tab of the drill-through report editor, in the report grid, select the column to work with and then click in the cell under the Sort Order column heading to activate the drop-down list control.
Choose the Asc (ascending order) or Desc (descending order) option.
Repeat step 1 and step 2 for each column to which you want to apply a sort order.
Use the Move Up and Move Down buttons to arrange the order of the columns in the drill-through report.
Columns are displayed in a report from left to right in the order in which they are listed from top to bottom in the report grid. Arrange the columns in the report grid in the order in which you want them to be displayed in the drill-through report.