Is there a support built into 2008.2 release to customize the ultragrid grouping operation?
I have a DateTime column and I would like to give the user the possibility to choose between a yearly/quarter or monthly group.
Thank you.
Hi,
There's a property on the grid column called GroupByMode, which has a whole bunch of options including Month, Year,and Quarter.
I'm not sure what version this feature was added in, but I think it was probably before v8.2, so take a look and see if the property shows up in intellisense.
If it's not there, you could either upgrade, or write your own custom GroupByComparer for the column.
Hi, just noticed something, we're running 12.1.20121.2082 and GroupByMode.Quarter on a DateTime column is flaky. Outlook, date, month, year are all correct, but Quarter produces mixed results. I have a bunch of rows all with a column of oct and sept dates... I'll get a mix of repeated Q4 and Q3. the child rows are correct between oct and sept, but i should be getting only 2 parent bands Q4 and Q3, not repeats. Did this break and or get fixed in a hot fix? thanks
I tried this out and I think you are correct, the Quarter grouping does not seem to be working correctly. I have forwarded this thread over to Infragistics Developer Support so they can write this up for developer review and we can get it fixed.
Please note that v12.1 is retired, though, so any fix we provide for this will only be available in the later supported versions.
Les,
This issue has been submitted to our development team with reference number 153970. A support case has also been opened for you with reference number CAS-124496-K6N5J1.
You will receive more information on this item through the support case.
Hi, the good news is the GroupByMode.Quarter is working, so this case is closed, but... I just noticed group by is still flaky with GroupByMode.Date. If you first group by DATE and then group by a column of text the 2nd group level text items can be duplicated and not grouped into one band. This ONLY happens if the first group by is DATE, all others work correctly i.e. OutlookDate. I can email a screen shot image if you'd like.
Using 13.2.20132.2010
I tried this out and I'm not seeing any problems. I have attached my sample project here so you can see if you get the same results of maybe there is some other factor in your application that is causing the behavior.
Just to be clear, the 1st column that is grouped by DATE is correct, it's the 2nd level text column that will not always be grouped correctly. And this 2nd level group by column will only be incorrect if the 1st group by is DATE, if the 1st column is any other GroupByMode then the 2nd level is correct.