This is not a bug. This is a limitation into the RadPivtoGrid – there is not property for formatting the text into the FilterWindow’s ListBox items. The PivtoGrid fields’s DataFormatString is applied over the calculated fields not on the FilterWindow’s ListBox items. A possible workaround here is to handle the RadPivotGrid.FilterWindow.SetBox.ItemCreated event and to format the text manually:
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
RadPivotGrid1.FilterWindow.SetBox.ItemCreated += SetBox_ItemCreated;
}
void SetBox_ItemCreated(object sender, RadListBoxItemEventArgs e)
{
if (e.Item.Value != "SelectAll" && RadPivotGrid1.FilterWindow.IsReportFilter)
{
e.Item.Text = String.Format("{0:dd/MM/yyyy}", Convert.ToDateTime(e.Item.Text));
}
}