GGC : Grouping columns

[Anupama]

I have a grid in which 2 of the columns are CategoryID and CategoryDesc. I want categorize based on categoryid but in the CaptionText I want to show the CategoryDesc. How can I do that?
None of the captiontext tokens allow you to select text from another column.

[stanleyj]

Hi Anupama,

The text in caption cell can be changed handling the QueryCellStyleInfo handler.

private void gridGroupingControl1_QueryCellStyleInfo(object sender, GridTableCellStyleInfoEventArgs e)
{
if(e.TableCellIdentity.TableCellType == GridTableCellType.GroupCaptionCell)
e.Style.Text = "My Text";
}

Best regards,
Stanley

[Anupama]

Thanks Stanley! That worked.

[Anupama]

How can I get the tokens to display programatically in the Caption Text?
Specifically the {RecordCount} token. The documentation says this comes from the CaptionSection.ParentGroup.GetFilteredRecordCount() but CaptionSection is a member of which class in e.TableCellIdentity? (I need to write this piece of code in QueryCellStyleInfo event handler).

>Hi Anupama,
>
>The text in caption cell can be changed handling the QueryCellStyleInfo handler.
>
> private void gridGroupingControl1_QueryCellStyleInfo(object sender, GridTableCellStyleInfoEventArgs e)
> {
> if(e.TableCellIdentity.TableCellType == GridTableCellType.GroupCaptionCell)
> e.Style.Text = "My Text";
> }
>
>Best regards,
>Stanley

[stanleyj]

Hi Anupama,

Let me know if this will work for you.

e.TableCellIdentity.DisplayElement.ParentGroup.GetFilteredRecordCount()

Best regards,
Stanley

[stanleyj]

Hi Anupama,

Let me know if this will work for you.

e.TableCellIdentity.DisplayElement.ParentGroup.GetFilteredRecordCount()

Best regards,
Stanley

[Anupama]

Yes! This works exactly the way its supposed to. Thanks!

>Hi Anupama,
>
>
>Let me know if this will work for you.
>
>e.TableCellIdentity.DisplayElement.ParentGroup.GetFilteredRecordCount()
>
>Best regards,
>Stanley