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