Hi,
I've tried make my grid group by a "DateTime" column based on the Date rather than Date & Time. If I just use the default Group By header and drag my datetime column into the group by header, it groups the row by the exact date & time, which made each row its own group since all rows does not have the exact date & time (i.e. there are many rows within one day but different times).
Thanks!
private void ultraGrid1_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e) { e.Layout.Bands[0].Columns["DateTime 1"].GroupByMode = GroupByMode.Date; }
You might want to try GroupByMode.OutlookDate, instead.
Thank you Mike, that worked like a charm! By the way, when I grouped the rows, the group by header shows "DateTime: 6/27/2006 (2 items)", is there anyway to override the default text and make it shows "Tuesday, Jun 27, 2006 (2 Records)" or some other custom text? Or better yet, change the color and apperance of the group by header? Thanks!