Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
115
Need help in Grid Group By Functionality
posted

Hi,

 We are facing a problem while Multilevel Grouping. 

Requirement:

For Some fields  we should be able to Group them in our own set of buckets. The number of buckets depends on Quantile type set by the User.

For e.g.

If the user says Field_ Name _1 - Quartile that means this Column should be grouped in 4 equal buckets. This we are able to achieve at single level with the help of GroupByEvaluator Class.

Now, if the user selects another level, each bucket of Field_ Name _1 - Quartile should be again divided into subgroups depending upon the Quantile type of the next level column. Finally the user would be viewing 4 Field_ Name _1 groups in each of which there will be 4 Field_ Name _1 groups. 

Infragistics solution: We can specify a custom evaluator here (i.e., an object of type IGroupByEvaluator, which is internally used by the grid). This allows us to control how and when the results are broken into groups. 

Problem:

For Multilevel grouping of these fields, what we want is, the ability to call this class for respective Groups(for each Bucket). So that, each bucket can be subdivided.

We do not have the control over when the GroupByEvaluator methods called by Grid. And while multilevel grouping, the call to this class for each group is parallel, because to this we do not have 1st level of grouping ready, so that it can be used to generate subgroups.

 

Any help/suggestion would be great .

 

Thanks,

Abhinav

  • 138253
    Offline posted

    Hello Abhinav,

     

    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. I have been looking through your post and I created a sample project for you. Basically I created two custom GroupByEvaluators and when the user groups by the main one I group the records by the other one immediately. The second one is set to an UnboundField, which is Hidden.

     

    Feel free to write me if you have further questions.

     

    xamDataGridGroupInGroup.zip