Exago Logo
Search
Generic filters
Exact matches only

Report Wizard: Sorts

Sorting is the process of ordering your data rows by a certain sequence. For each available data category, you can choose which data field should be used to sort the rows. Fields can be sorted in ascending or descending direction. The way in which rows are sorted depends on the type of value in the field:

Numeric
custom.arrow_fore.png Asc  Lower values     Higher values  Desc custom.arrow_back.png

Date
custom.arrow_fore.png Asc  Past     Future Desc custom.arrow_back.png

Text
custom.arrow_fore.png Asc  A     Z Desc custom.arrow_back.png

custom.DepartmentsUnsorted.png

A list of employees, sorted by their last name in Ascending order

custom.DepartmentsSorted.png

The same list of employees, sorted by their department name in Ascending order

A report can have multiple sorts. This can be useful when you want your highest precedence sort to affect a data field where the values for multiple rows may be the same.

For example, imagine a large company with many employees. There could be multiple people with the last name Buchanan. With only a sort on LastName, you do not know how all the people with the last name Buchanan will be ordered amongst themselves. If this matters, then you can add a second sort on, say, the FirstName field, so that people with the same last names will be ordered by their first names.

Adding sorts

On the Sorts page, add data fields to sort. The precedence of the sorts starts with the highest row and moves down the list. Drag the rows up or down to change the precedence.

screen.reportwizard_drag_sort_field.png

Dragging a field to the Sort By pane

Tip

Sorts apply to all report types except CrossTab Reports.

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Table of Contents