PivotGrid Grouping

[Andrew]

Is there a way to turn off grouping of items with the pivot grid.  I'm passing in a dataset with hundreds of rows containing a numberical ProductID column.

When I place this ProductID into the row labels section it automatically groups the products into two ranged groups.  We need this data at a more granular level.  Is this possible?

[Ivan Todorov]

Hi Andrew,

Thank you for contacting us.

When using numeric fields the RadPivotGrid automatically creates DoubleGroupDescription which is suitable in the case when the numeric field represents some kind of measure. The DoubleGroupDescription uses its Step property to determine the value range in which entries will be grouped. If you want to prevent grouping at all, you should use the PropertyGroupDescription which puts in the same group only entries with the exact same value. The following snippet demonstrates how to add a PropertyGroupDescription:

this.radPivotGrid1.ColumnGroupDescriptions.Add(new PropertyGroupDescription() { PropertyName = "EmployeeID", GroupComparer = new GrandTotalComparer() });

I hope this will help you. Please let me know if you have any further questions.

Regards,
Ivan Todorov
Telerik

[KUMARAN]

The above snippet works,but when i dropped out that field and again i select  that field  it  display as like earlier
(Ranged Groups)

[Ralitsa]

Hi Kumaran,

Thank you for contacting us. 

You can refer to the following forum thread Pivot Grid Row Label which contains code snippet and sample project. 

Hope this will help you. Let me know if you have any another questions.

Regards,
Ralitsa
Telerik