Grouping and Sorting

The Grouping Grid Control when bound to a datasource can be used to performing engine related operations such as grouping and sorting. Grouping allows you to categorize the records based on a specific column. Through sorting, you can arrange the table data either in ascending or in descending order of values in the selected column.

The records displayed on the grid can be grouped by one or more columns. For example, you can group the records by the Country field and by the State field.

Grouping can be setup in the program and also be initiated by the user.

The user can simply drag and drop the column header that he/she wants to group by to a Group Drop Area located at the top of the grid,to group by a particular column.

On completion of the grouping command, the records with matching values in the grouping column are combined together to form a group. Every such group is captioned by a group bar. Each group bar is prefixed with a Plus/Minus button. using this button, the underlying records of the group can be viewed or hidden.

The data in the grid can be sorted. Default setting allow all columns on the grid to be sorted. Sorting allows you to rearrange the record values either in ascending or in descending order of the sorted column values. Sorting can be achieved by either setting up the program or defined by the user during runtime. You can sort on any datagrid column by clicking over the desired column.

Sorting can be applied on more than one column. The sort direction for the individual columns will be displayed in the corresponding column headers. Options for clearing sort and avoiding sort on a specific column are also available. To achieve multi-column sorting, click the desired column headers by holding the CTRL key.