Custom Grouping

[Siva Vasanthan]

Hi,
Currently I am setting the DataSource of a GroupingGrid to a Datatable and trying to do the grouping based on a number of columns(based on 3 columns of each rows). I am setting those three columns to GridGroupingControl.TableDescriptor.GroupedColumns property of the control.

But, what is happening is that when the second and third grouping fields are empty on a particular row, it is creating empty grouping for second and third level and adding those rows (records) under that hierarchy.

But, what I want in that situation is that simply drop those rows under the first level of grouping without creating second and third empty groupings.

I am wondering whether there is a property I can set in the grouping grid control to do that to customise the grouping mechanism or can I override a method in the grouping grid to do that.

Thanks in advance,
Siva.

[Siva Vasanthan]

I can drop a screen shot to describe this if that helps,

Thanks,

[Siva Vasanthan]

Also, the groupings are currently based on the alphabetical order. Can we change the ordering based on a custom ordering?

[Siva Vasanthan]

Alternatively, can we hide the empty grouping heading rows?

[Administrator]

Here is a sample that shows how you can not display the group caption row if the group only a few members.

http://www.syncfusion.com/Support/user/uploads/ConditonalCaptions_1e92005a.zip

To do custom sorting or grouping, you can use a custom categorizer. Here are some links to forum threads that have samples in them.

http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=15751

http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=26206