DataFormatString Not Working

[steve]

I cant seem to get formatting working in the Pivot Grid. For example, here us the code, but the date is always shown unformatted.

        <telerik:PivotGridRowField Caption="TransDate" DataField="TransDate" SortOrder="Descending"
            DataFormatString="{0:MM/dd/yy}">

[Milena]

Hello,

Indeed I could replicate the same problem on my end. It is first time reported. I am logging it as a bug in our tracking system and our developers will have the care to fix it. Your Telerik points are updated accordingly.
You can follow the PITS Issue by its ID: 12368
Here you can find the PITS Issue: Public URL

Kind regards,
Milena
the Telerik team

[Morten]

Hi,

Has this problem been solved? I have the same problem with the date format string not working for Row header total (Telerik.web.ui version 2013.1.417.40). Have a look at the attached image.

<telerik:PivotGridRowField DataField="StatusDate" Caption="Status date" DataFormatString="{0:dd-MM-yyyy}" TotalFormatString="{0:dd-MM-yyyy}"></telerik:PivotGridRowField>

[Milena]

Hello,

Indeed I could replicate the same problem on my end. I am logging it as a bug in our tracking system and our developers will have the care to fix it. Meantime, you can use the following code as a possible workaround:

protected void CellDataBounded(object source, Telerik.Web.UI.PivotGridCellDataBoundEventArgs e)
      {


          PivotGridRowHeaderCell headerCell = e.Cell as PivotGridRowHeaderCell;

          if (headerCell != null && headerCell.IsTotalCell && headerCell.Field.DataField == "FieldName")
          {

                  headerCell.Text = "Test";


          }
      }

Regards,
Milena
the Telerik team