Sort Data

You can organize the data in a report by specifying a sort order. Data can be organized in ascending or descending sort order based on the values in any data item. You can sort the data in many different report elements. For a complete list of these elements, see sortList.

For information on sorting data that comes from a dimensional data source, see the Reporting User Guide.

Procedure

Add the sortList element to the list element.
Add a sortItem element to the sortList element. Use the refDataItem element to specify the data item to sort. Use the sortOrder attribute to specify whether to sort the data in ascending or descending order.
Sample XML
```
<list name="List1" refQuery="Query1">
 ...
  <listColumns>
  ...
  </listColumns>
 <sortList> 
  <sortItem refDataItem="Revenue" sortOrder="descending"/> 
 </sortList> 
</list>
```