I'm trying to use the RadGridView AggregateFunctions. I've tested Count, Min and Max functions successfully. However, when I try using SumFunction or AverageFunction, nothing is displayed on the column footer (including the previously added Count, Min, Max functions).
I'm binding a DataTable to the grid from C# like this:
this.radGrid1.ItemsSource = dtData; |
This is the XAML for the GridView:
<telerikGrid:RadGridView |
x:Name="radGrid1" |
MultipleSelect="True" |
AutoGenerateColumns="False" |
ShowColumnFooters="True" ShowGroupFooters="True"> |
<telerikGrid:RadGridView.Columns> |
<telerikGrid:GridViewDataColumn Header="AccountNo" DataMemberBinding="{Binding AccountNo}"> |
<telerikGrid:GridViewDataColumn.AggregateFunctions> |
<telerikData:CountFunction Caption="Count:" /> |
</telerikGrid:GridViewDataColumn.AggregateFunctions> |
</telerikGrid:GridViewDataColumn> |
<telerikGrid:GridViewDataColumn Header="InvestmentCost" DataMemberBinding="{Binding InvestmentCost}" DataFormatString="{}{0:c}" TextAlignment="Right"> |
<telerikGrid:GridViewDataColumn.AggregateFunctions> |
<telerikData:SumFunction ResultFormatString="{}{0:c}" SourceField="InvestmentCost" /> |
<telerikData:MinFunction ResultFormatString="{}{0:c}" SourceField="InvestmentCost" /> |
<telerikData:MaxFunction ResultFormatString="{}{0:c}" SourceField="InvestmentCost" /> |
</telerikGrid:GridViewDataColumn.AggregateFunctions> |
</telerikGrid:GridViewDataColumn> |
</telerikGrid:RadGridView.Columns> |
</telerikGrid:RadGridView> |
Edit:
DataType for InvestmentCost column in dtData is Decimal.
I'm using RadControls for WPF Q3 2009 SP1