I need to Group a particular column based on its row value. what i mean to say is if i have a column with value range from 1 to 100 , i want that column to grouped into certain buckets like from 1 to 20 should come in one bucket and 2 to 20 should come in other...?
Any idea how can i acheive this? I tried for GroupbyEvaluator but coulnd find much info on that:(
Hello,
It has been a while since you have made your post, in case you still need support I will be glad to assist you further. I suppose the other community members can benefit from this answer as well. So I have been looking through post and I created a sample project for you with a custom GroupByEvaluator. You can read more about how to do so here:
http://help.infragistics.com/NetAdvantage/WPF/2011.1/CLR4.0/?page=InfragisticsWPF4.DataPresenter.v11.1~Infragistics.Windows.DataPresenter.IGroupByEvaluator.html
Feel free to write me if you have further questions.
I tried out your example, after finding a problem with my own code, and it shows the same problem. When you use custom grouping, the count of the number of items is no longer shown.
For instance, if I group by Patient, I get the counts [(2 items) etc.] on each group.
But if I group by Dosage, I only get the name of the group (0-33, 33-66, and 66-100), but the counts are missing.
This is going to be a big issue for us, because I want to apply a case-insensitive grouping to all String columns, so I will be losing the counts on all of those columns.
Is there a way to have custom grouping and the counts?
Thanks,
Mike