In standard reports, users can independently set the data sorting by utilizing the "Change Report Variant" option.
To add a new sort, navigate to the menu and select "More Actions" followed by "Change Report Variant." The Sort tab is available for this purpose.
The left column shows all the attributes you can sort in the current report. Some attributes have related data, marked by a "+" sign next to them. This related data can also be used for sorting and filtering.
To sort the data, simply drag the desired attribute to the left side and choose the sort order (ascending or descending). You can also add multiple 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:
After saving the sort settings, the report will be generated as follows:
Data will be sorted based on the order set in the Sort tab. Standard reports usually have default sorting, but users can add or edit sorts. For periodic reports, sorting is needed to show data in chronological order.
Without this sorting, periodic reports may be shown in a random order by the system.
If a user frequently needs to use specific settings, they can save a new report variant with the additional sortings.
Thank you for being a FirstBit customer! #Sorting #Ascending #Descending #report