DataFormatString and FooterText problem

[Ernest Mombay]

Hello.

I've got a bit of problem. If I declare a column in a grid with a specific DataFormatString, then create an aggregate of it with FooterText, the text does not show up. So this code snippet below

<telerik:GridBoundColumn HeaderText="Column1" SortExpression="Column1"
                DataField="Column1" UniqueName="Column1" DataType="System.Decimal"
                DataFormatString="{0:$###,##0.00}" Aggregate="Sum" ItemStyle-Wrap="true" HeaderStyle-Wrap="false"
                FooterText="Total Column1: ">
                <ItemStyle HorizontalAlign="Right" Wrap="True" />
                <FooterStyle HorizontalAlign="Right" Wrap="True" />
            </telerik:GridBoundColumn>

would show the column with currency format but the will not show the right footer text. However, once I remove the DataFormatString setting, the footer text displays. However, I need to have the currency formatting in place. Is there a better way for me to do this, or are we not allowed to do this?

Thanks,
Ernest

[Daniel]

Hello Ernest,

I tried to reproduce this behavior on my end but unfortunately to no avail. Could you please check the attached project to see whether I'm not leaving out something important?

Regards,
Daniel
the Telerik team

[Ernest Mombay]

Hmm... I loaded your sample project, and it's still not showing the footer text. I expected the footer to say:

Total Column1: $999.99

But when I opened your project and linked our Telerik library, all I got was

$999.99

Maybe it's the version of Telerik we are using? I'm on v. 2010.2.929.35

[Tomer]

Hi,
what was the solution if i may ask?
was it really a version problem? i have the same problem here.

[Daniel]

Hello Ernest and Tomer,

Sorry, I misunderstood the problem. When using DataFormatString and aggregates, you should specify the footer text in the FooterAggregateFormatString:

FooterAggregateFormatString="Total Column1: {0:$###,##0.00}"

Best regards,
Daniel
the Telerik team

[Tomer]

Thanks.