Format Column Group Header

[Shaun]

Hi,

I have the following

provider.ColumnGroupDescriptions.Add(new PropertyGroupDescription() { PropertyName = "DispatchDate", GroupComparer = new GroupNameComparer() });
provider.ColumnGroupDescriptions[0].SortOrder = Telerik.Pivot.Core.SortOrder.Ascending;

DispatchDate is a Datetime field.

So far so good.

But can I format the date field to read MM YY (May 14) in the column header?

I tried to change the DispatchDate to a string, but that messes up the sort, so if I could format the date field that would be great.

Thanks
Shaun.

[Dimitar]

Hello Shaun,

Thank you for writing.

As the following code snippet demonstrates, you should use the GroupElementFormatting event to change the header cells text:

void radPivotGrid1_GroupElementFormatting(object sender, Telerik.WinControls.UI.PivotGroupElementEventArgs e)
{
    DateTime Value ;

    if (DateTime.TryParse(e.GroupElement.Data.Name, out Value))
    {
        e.GroupElement.Text = String.Format("{0:MMM yy}", Value);
    }
}

Please let me know if there is something else I can help you with.

Regards,
Dimitar
Telerik

 

 

[Shaun]

Hi Dimitar,

Thanks for your help, works a treat.

Cheers

Shaun