How to remove sorting from a worksheet

When you no longer want to sort a worksheet, you can remove the sort(s) from the worksheet. For example, you might have created a temporary sort to produce an ad hoc report that you now want to remove.

Table worksheets and crosstab worksheets behave differently, as follows:

• On table worksheets, you can remove all sorts to display data in the order in which it is stored in the database.

• On crosstab worksheets, you can remove additional sorts that you have added to the worksheet but you cannot remove the original default sort.

Note: Crosstab worksheets are group sorted automatically (for more information, see "About sorting on crosstab worksheets").

To delete a sort:

1. Display the sorted worksheet that you want to edit.

2. Choose Tools | Sort to display the Sort dialog (see "Edit Worksheet dialog" or "Edit Worksheet dialog".

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

3. Select the item that you want to remove.

4. Click Delete to remove it from the sort list.

   Note: On crosstab worksheets, you cannot remove the original default sort (see "About sorting on crosstab worksheets").

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

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