In standard reports, the user users can independently set the sorting of data using Change the report variant. Use the menu More actions - change report variant to 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 providedavailable for this purpose.
It lists in the The left column shows all the attributes available for you can sort in 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 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 specify choose the sort order (ascending , or descending). It is You can 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 After saving Sort the sort settings, the report will be generated in following wayas follows:
In this case, the data Data will be sorted in based on the order set 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 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