Retrieves or sets a value that indicates whether the group sorts automatically the
data when the user click on column's caption.
| Type | Description | ||
| SortOnClickEnum | A SortOnClick expression that indicates whether the group sorts automatically the data when the user click on the column's caption. |
Use the SortOnClick property to disable sorting items when the user clicks on the column's header.
There are two methods to get the items sorted like follows:
Using the SortOrder property of the Column object::
Group.Columns(ColIndex).SortOrder = SortAscending
The SortOrder property adds the sorting icon to the column's header, if the DisplaySortIcon property is True.
Using the SortChildren method of the Items collection. The SortChildren sorts the items. The SortChildren method sorts the child items of the given parent item in the group. SortChildren will not recourse through the tree, only the immediate children of the item will be sorted. The following sample sort descending the list of root items on the "Column 1"( if your group displays a list, all items are considered being root items ).
Group.Items.SortChildren 0, "Column 1", False