Sorting Tables

In the Ad Hoc Editor, you can sort the rows of a table by any field, using a number of different methods.

To sort a table, complete the following steps:
 

• Click the Sorting icon .The Sort window appears. If the table is already sorted, the window shows the fields that are used.
  
  

• To add a field to sort on, double-click the field in the Available Fields panel. The Available Fields panel now lists only fields that are not already in the Sort On panel.
  
  

• Select one or more fields to sort by. You can also use Ctrl-Click to select multiple fields.
  
  

• Click the Move to Right button to add the selected field to the Sort On panel.
  
  

• To arrange the sorting precedence of the fields, select each field in the Sort window and click one of the following buttons:
  
  

  Move to Top	Move to Bottom	Move Up	Move Down

  
  
  

• To remove a field from the Sort On panel, select it and click the Move to Left button .
  
  

• Click the OK button. The table updates to display the rows sorted by the selected fields. You can also sort a table using the following methods:
  
  

  • In the Fields section of the Domain Selection panel, right-click a field and select Use for Sorting from the context menu. In this case, the table is sorted by a field that isn't in the table; you may want to note the sorting fields in the title.
    
    

  • On the canvas of the Ad Hoc View panel, right-click a column header and select Use for Sorting from the context menu.