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.