How to group on a continuously-valued column by value ranges?

[Administrator]

I know the Subject is not really understandable, so let me elaborate...

let's say i have a 'Price' column in a GGC, and the value of prices varies between 80 to 110. i want to specify three price ranges: (80, 90), (90, 100), and (100, 110), then group all the records based on the ranges. So after the grouping, the grid will show three groups for each range, and the records will fall into each group based on the value of its price.

is there an easy way to accomplish this? thanks,

Frank

[Administrator]

Hi Frank,

One way you can do this is to add an Expression column to your GridGroupingControl where the expression accepts a value and then returns a groupID value that identifies values between 80 to 90 with the same ID, values 90-100 with another ID, and so on. Here is a KnowledgeBase article that shows you "How to create custom group in a GridGroupingControl?".

http://www.syncfusion.com/support/kb/grid/Default.aspx?ToDo=view&questId=147

Best regards,
Haneef