how String.Format of RadGrid(Telerik) Sum result in footer?

[Majid Darab]

hi dear telerik team :
my radgrid column like below :

<telerik:GridTemplateColumn FilterControlAltText="Filter TemplateColumn_Benefit" DataField="Benefit"
                    HeaderText="Benefit" UniqueName="TemplateColumn_Benefit" FilterImageToolTip="Filter">
                    <ItemTemplate>
                        <asp:Label ID="lblBenefitInsideGrd" runat="server" Font-Size="11px" Text='<%# (bool)Convert.IsDBNull(Eval("Benefit")) ? "<span class=\"lblInsideGrd\">Empty</span>" : String.Format("{0:#,0 Dollar;#,0- Dollar}", Eval("Benefit")) %>'></asp:Label>
                    </ItemTemplate>
                    <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Width="60px" />
                    <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Width="60px" />
                </telerik:GridTemplateColumn>

how can i String.Format(reformat) Sum result in footer for this template column ?
mean i want something like {0:#,0 Dollar;#,0- Dollar} in output...

best regards

thanks in advance

[Phil]

Hi:
Check out CustomAggregate event and set e.Result = String.Format( ...
Phil