Specialized Administration > Analyzing System and Business Information > Reports and Queries > Query Builder > Sort (Query Builder)
  
Sort (Query Builder)
The Sort tab allows you to specify the sort order of the data returned from the query. The Sort tab is active only if there are sortable items present in the report template.
* 
This information is used to build the SQL ORDER BY clause of the query. Because this is a database sort, the language and sort settings of the database apply.
To specify the sort order, click add to add new rows to the table. For each row, select the following information:
• In the Display Name field, select the alias of the attribute on which you want to sort. The drop-down list contains the Display Name for each sortable item as specified on the Select or Constrain tab.
• In the Order field, specify whether the attribute is sorted in Ascending or Descending order.
The order of the rows determines the order in which the sorts are performed. Use drag-and-drop to reorder the rows.
To remove a row from the table, select the row and click delete . Multiple rows can be selected for deletion.