Hi,
I am using 2015.1.401.40 of your ASP.NET controls for AJAX.
One of my PivotGridColumnField's is a smalldatetime field from SQL Server.
In the PivotGrid column header labels I want the dates to be formatted as MMM-yy, like Aug-15.
I can accomplish that for the detail columns (the non-aggregate columns) by setting the DataFormatString="{0:MMM-yy}"
But that doesn't affect the label of the column total header. That header label reads: "08/01/2015 00:00:00 Total"
Again, my goal is to have it read: Aug-15 Total
How can I accomplish this? I can't believe there isn't a property to control it...
I've seen a couple of suggestions where people were told they should change the header text in the CellDataBound Event, but the problem is that in this event I don't seem to have access to the date value. I have only seen that I can read the current header text which again is a string of a date and the word "Total".
I don't want to strip the word "Total" out of that string and then then convert the date that remains to a string in the date format I want. We do localization here so I would imagine that if my culture was something other than English, the word "Total" would be translated into another language.
If there isn't a neat and clean way to do this, it seems like a big oversight (missing functionality) on the part of the pivotgrid.
Thanks,
Brent