Sort Criteria Tab Overview

By default, the system lists assets in the Asset List according to System Number. In reports, they are also ordered by book. The Sort Criteria tab in the Add/Edit Group window allows you to change the order in which the system lists assets in the Asset List and in reports. You can also indicate whether you want subtotals to appear for each sort level. There is information critical to creating complex sort criteria in Complex Expressions. Refer to it if you plan to build such a sort.

Note: You can override the sort criteria that you select on the Sort Criteria tab when you run reports.

The application sorts fields first by number, then by uppercase letters, and finally by lowercase letters. If you select descending order, this order is reversed.

The order in which you select fields to sort is important. The first field determines the primary sort order. The next field determines the sort order within the primary group. The third field determines the sort order within the secondary group. If you do not select a secondary sort field, the system lists the assets within the primary sort group in order by System Number.