Help needed on GridGroupingControl

[Administrator]

Hi,

I try to use gridgroupcontrol to display records in a collapse view grouped by dates.
I used the codes below to show caption on date value. However, I need to change the format of the date (datetime type) as format as JAN06, instead of the datetime. Cannot figure out a way to do it.

Also, how can I get rid of the empty row after the caption. It shows as default, which is not useful for me.

Thanks a lot
this.grid.ChildGroupOptions.ShowCaptionPlusMinus = true;
this.grid.ChildGroupOptions.CaptionText = "{Category}";
this.grid.ChildGroupOptions.CaptionText = this.grid.ChildGroupOptions.CaptionText.Substring(0,5);
this.grid.ChildGroupOptions.ShowCaption = true;
this.grid.ChildGroupOptions.ShowColumnHeaders = false;

[Administrator]

You can use the QueryCellStyleInfo event and look for the e.TableCellIdentity.TableCellType == GridTableCellType.GroupCaptionCell

and just set the e.Style.Text to whatever you would like.

[Administrator]

Thanks. But I am trying to grab the data from one cell (know the col index already). I can figure out the row index and the event is triggered, but I cannot find the right method to grab the value. Would you show me several lines of sample codes?
Thanks

>You can use the QueryCellStyleInfo event and look for the e.TableCellIdentity.TableCellType == GridTableCellType.GroupCaptionCell
>
>and just set the e.Style.Text to whatever you would like.

[stanleyj]

Hi Chrisben, Please refer this thread. http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=11530 Best reagrds, Stanley

[Administrator]

thanks a lot