In standard reports, the user can independently set the sorting of data using Change the report variant.
Use the menu More actions - change report variant to add a new sort, the Sort tab is provided.
It lists in the left column all the attributes available for the current report that can be sorted by. Some attributes have nested (related) data, which can be seen through the + to the left of the attribute. Nested data can also participate in sorting and report filters.
The user needs to drag the desired attribute to the left side and specify the sort order (ascending, descending). It is also possible to add multiple data sorts in one report.
For example:
in an Employee list report user wants to sort departments in alphabetical order, and within employee departments by date of birth. This can be done like this:
Then after saving Sort settings report will be generated in following way:
In this case, the data will be sorted in the order in which the sorts were added to the Sort tab.
For most standard reports, data sortings are configured by default, but the user can add additional ones, as well as edit existing ones on the Sort tab.
The user also needs to use sorting when setting up a periodic report (if columns with a period are added - day, month, half-year, year, etc.) - to automatically display report data in chronological order:
(Without this sorting, reports by period may be displayed by the system in random order).
In case when user needs to use his additional settings often, he can save new report variant with additionla sortings.
Thank you for being FirstBit customer!