Formating GroupCaptionCell

Syncfusion 6.1
VS 2005

I'm grouping by 3 columns, one is a string, another a date and another a number. I want to format the groupcaptioncells based on the type of data being displayed. For instance I want the date in the groupcaptioncell to be displayed in a certain format, same with number. Can this be done without using the QuerycellStyleInfo event and checking the value?

Hi Shek,

This can be achieved by using GroupByOptions.CaptionText property. Please refer the code:


gridGroupingControl1.TableDescriptor.Columns["StringColumn"].GroupByOptions.CaptionText = "MyName";



Please try this and let me know if this helps.

Regards,
Jisha

Jisha...I'm not sure I understand the soltuion you proposed. I'm trying to set the formatting on the groupcaptioncells, not the caption text.

Thanks

>Hi Shek,

This can be achieved by using GroupByOptions.CaptionText property. Please refer the code:


gridGroupingControl1.TableDescriptor.Columns["StringColumn"].GroupByOptions.CaptionText = "MyName";



Please try this and let me know if this helps.

Regards,
Jisha

Hi Shek,

Thank you for your update.

You can use Format property of GroupByAppearance.GroupCaptionCell to format the GroupCaptionCell.

Please refer the code:



this.gridGroupingControl1.TableDescriptor.Columns["Col3"].GroupByOptions.CaptionText = "{Category}";
this.gridGroupingControl1.TableDescriptor.Columns["Col3"].GroupByAppearance.GroupCaptionCell.Format = "MMM";
this.gridGroupingControl1.TableDescriptor.Columns["Col3"].GroupByAppearance.GroupCaptionCell.CellValueType = typeof(System.DateTime);




Regards,
Jisha

Jisha..thanks for the response. I used the code piece you suggested, but still can't seem to format the date values in the groupcaptioncell. Attached is a sample.
Thanks



>Hi Shek,

Thank you for your update.

You can use Format property of GroupByAppearance.GroupCaptionCell to format the GroupCaptionCell.

Please refer the code:



this.gridGroupingControl1.TableDescriptor.Columns["Col3"].GroupByOptions.CaptionText = "{Category}";
this.gridGroupingControl1.TableDescriptor.Columns["Col3"].GroupByAppearance.GroupCaptionCell.Format = "MMM";
this.gridGroupingControl1.TableDescriptor.Columns["Col3"].GroupByAppearance.GroupCaptionCell.CellValueType = typeof(System.DateTime);




Regards,
Jisha





DateGridGroupingTest_704d8739.zip

Any word on this? Appreciate a response. Thanks

>Jisha..thanks for the response. I used the code piece you suggested, but still can't seem to format the date values in the groupcaptioncell. Attached is a sample.
Thanks



>Hi Shek,

Thank you for your update.

You can use Format property of GroupByAppearance.GroupCaptionCell to format the GroupCaptionCell.

Please refer the code:



this.gridGroupingControl1.TableDescriptor.Columns["Col3"].GroupByOptions.CaptionText = "{Category}";
this.gridGroupingControl1.TableDescriptor.Columns["Col3"].GroupByAppearance.GroupCaptionCell.Format = "MMM";
this.gridGroupingControl1.TableDescriptor.Columns["Col3"].GroupByAppearance.GroupCaptionCell.CellValueType = typeof(System.DateTime);




Regards,
Jisha





DateGridGroupingTest_704d8739.zip

Hi Shek,


Sorry for the delay in getting back to the issue.


You can handle the QueryCellStyleInfo event to solve this. See the below code snippet for more details.



// In form load
this.gridGroupingControl1.TableDescriptor.Columns["Criteria Value"].GroupByOptions.CaptionText = "{Category}";


this.gridGroupingControl1.QueryCellStyleInfo += new Syncfusion.Windows.Forms.Grid.Grouping.GridTableCellStyleInfoEventHandler(gridGroupingControl1_QueryCellStyleInfo);


void gridGroupingControl1_QueryCellStyleInfo(object sender, Syncfusion.Windows.Forms.Grid.Grouping.GridTableCellStyleInfoEventArgs e)
{
if (e.TableCellIdentity.TableCellType == GridTableCellType.GroupCaptionCell)
{
GridCaptionRow gcr = e.TableCellIdentity.DisplayElement as GridCaptionRow;


if (gcr.ParentGroup != null && gcr.ParentGroup.Category != null && gcr.ParentGroup.Name == "Criteria Value")
{
e.Style.CellValueType = typeof(System.DateTime);
e.Style.Format = "dd MM yyyy";
e.Style.Text = string.Format("{0}", e.Style.CellValue);
}
}
}



Regards,
Jisha