[Solved] Change grouping based on data

[Christopher]

I have a grid with several columns, and I want to group the data.  I want the grouping to be based on certain aspects of the returned data.  The problem is that grouping is determined by the options of the DataSource, and it seems that once I request data and get results, changing the options of the DataSource has no effect. 

What I'm trying to do is this:
For the first four columns of the grid, if there is only one distinct item in that column, then do not group by that column.  If there are more than one distinct item in that column, do group by that column. 

I have tried reading the data, then changing the datasource options, then refreshing the grid, but the grid still renders with default grouping. 

Any tips/ideas? 

[Nikolay Rusev]

Hello Christopher,

You can only change the groups by defining new group descriptors and apply them through the DataSource.group method.

Regards,
Nikolay Rusev
Telerik