The order the data rows are returned when the report is generated can be specified. In our worked example we will use this feature to order by Top Depth.

To define a sort order simply click on the Sort check box next to the field name as shown below.

Sorting can be applied to all fields and you can sort by more than one field

The order with which the sorting is applied when more than one sort field is specified can be controlled using the Move Up and Move Down buttons on the Sort form. The Sort form can be accessed by clicking the Sort icon on the ribbon.

Orders are ascending by default. However you can make order descending by turning off the Ascending tick box next to the field in the Sort form as shown below.