How to change how worksheet data is sorted

You can change the sort order of worksheet data at any time. For example, to reverse the sort order, hide the sorted column, or change a sort into a group sort.

To edit a sort:

1. Display the worksheet that you want to sort.

2. Choose Tools | Sort to display the "Edit Worksheet dialog: Sort tab" or "Sort Crosstab dialog" (depending on the type of worksheet displayed).

   The Sort dialog displays current sort options in a sort list.

3. Edit the sort list as required.

4. Click OK to save the details and close the Sort dialog.

   Discoverer refreshes the worksheet according to the sort options that you select.