Grouping and sorting
Access grouping and sorting by clicking the Grouping/Sorting tab in the Layout Editor window.
NOTE: The Grouping/Sorting tab is not available if the report level is selected. In addition, grouping will not occur if the Expanding checkbox is deselected.
Figure: Grouping and sorting options
Icon | Function | |
1 | Increase or decrease the precedence of the data item in the sorting order. | |
2 | Select the display option of the row, column, or cell. The available options are None, Group, Sum, Min, Max, and Count. | |
3 | If this icon is displayed, the sorting is in ascending order for the group. Click on this icon to cycle through the sorting options. | |
3 | If this icon is displayed, the sorting will not exist for the group. Click on this icon to cycle through the sorting options. | |
3 | If this icon is displayed, the sorting is in descending order for the group. Click on this icon to cycle through the sorting options. | |
4 | Delete the data item from the Grouping/Sorting tab. |