[Solved] Grouped Grid does not shows a totals in the group footer

[Thomas]

I am stuck.
Can someone can see what I am doing wrong?
Using MVVM with following code,

 

 

<telerik:RadGridView ItemsSource="{Binding SearchItems, Mode=TwoWay}"

 

IsReadOnly="{Binding IsReadOnly}"

 

ShowGroupPanel="false"

 

AutoGenerateColumns="False"

 

ShowGroupFooters="True"

 

AutoExpandGroups="True"

 

Name="SearchGrid"

 

Grid.Row="1"

 

FrozenColumnCount="7">

 

 

<telerik:RadGridView.GroupDescriptors>

 

 

<Data:GroupDescriptor Member="GroupName">

 

 

<Data:GroupDescriptor.AggregateFunctions>

 

 

<Data:SumFunction SourceField="CalculatedTotal"

 

ResultFormatString="{}{0:C0}" />

 

 

</Data:GroupDescriptor.AggregateFunctions>

 

 

</Data:GroupDescriptor>

 

 

</telerik:RadGridView.GroupDescriptors>

 

 

<telerik:RadGridView.Columns>

 

 

<telerik:GridViewDataColumn Header="Account#"

 

DataMemberBinding="{Binding CodeId}"

 

IsReadOnly="True" />

 

 

<telerik:GridViewDataColumn Header="Dept#"

 

DataMemberBinding="{Binding DepartmentId}"

 

IsReadOnly="True" />

 

 

<telerik:GridViewDataColumn Header="Desc"

 

DataMemberBinding="{Binding Title}"

 

IsReadOnly="True" />

 

 

<telerik:GridViewDataColumn Header="Total"

 

DataMemberBinding="{Binding CalculatedTotal,Mode=TwoWay}"

 

DataFormatString="{}{0:C0}"

 

IsReadOnly="True">

 

 

<telerik:GridViewDataColumn.AggregateFunctions>

 

 

<Data:SumFunction SourceField="CalculatedTotal"

 

ResultFormatString="{}{0:C0}" />

 

 

</telerik:GridViewDataColumn.AggregateFunctions>

 

 

</telerik:GridViewDataColumn>

 

 

<telerik:GridViewDataColumn Header="% Sales"

 

DataMemberBinding="{Binding PreviousPercentOfSales,Mode=TwoWay}"

 

DataFormatString="{}{0:P2}"

 

IsReadOnly="True" />

 

 

<telerik:GridViewDataColumn Header="% Change"

 

DataMemberBinding="{Binding NextPercent,Mode=TwoWay, Converter={StaticResource PercentConverter}}"

 

IsReadOnly="False"

 

DataFormatString="{}{0:#.##}" />

 

 

<telerik:GridViewDataColumn Header="Fixed"

 

DataMemberBinding="{Binding NextTotal,Mode=TwoWay, Converter={StaticResource PercentConverter}}"

 

IsReadOnly="False"

 

DataFormatString="{}{0:C0}" />

 

 

<telerik:GridViewDataColumn Header="Nov"

 

DataMemberBinding="{Binding P1, Mode=TwoWay}"

 

DataFormatString="{}{0:C0}">

 

 

<telerik:GridViewDataColumn.AggregateFunctions>

 

 

<Data:SumFunction SourceField="P1"

 

ResultFormatString="{}{0:C0}" />

 

 

</telerik:GridViewDataColumn.AggregateFunctions>

 

 

</telerik:GridViewDataColumn>

 

 

<telerik:GridViewDataColumn Header="Dec"

 

DataMemberBinding="{Binding P2, Mode=TwoWay}"

 

DataFormatString="{}{0:C0}">

 

 

<telerik:GridViewDataColumn.AggregateFunctions>

 

 

<Data:SumFunction SourceField="P2"

 

ResultFormatString="{}{0:C0}" />

 

 

</telerik:GridViewDataColumn.AggregateFunctions>

　

 

 

</telerik:GridViewDataColumn>

 

 

<telerik:GridViewDataColumn Header="Jan"

 

DataMemberBinding="{Binding P3, Mode=TwoWay}"

 

DataFormatString="{}{0:C0}">

 

 

<telerik:GridViewDataColumn.AggregateFunctions>

 

 

<Data:SumFunction SourceField="P3"

 

ResultFormatString="{}{0:C0}" />

 

 

</telerik:GridViewDataColumn.AggregateFunctions>

　

　

 

 

</telerik:GridViewDataColumn>

 

 

<telerik:GridViewDataColumn Header="Feb"

 

DataMemberBinding="{Binding P4, Mode=TwoWay}"

 

DataFormatString="{}{0:C0}">

 

 

<telerik:GridViewDataColumn.AggregateFunctions>

 

 

<Data:SumFunction SourceField="P4"

 

ResultFormatString="{}{0:C0}" />

 

 

</telerik:GridViewDataColumn.AggregateFunctions>

　

 

 

</telerik:GridViewDataColumn>

 

 

<telerik:GridViewDataColumn Header="Mar"

 

DataMemberBinding="{Binding P5, Mode=TwoWay}"

 

DataFormatString="{}{0:C0}">

 

 

<telerik:GridViewDataColumn.AggregateFunctions>

 

 

<Data:SumFunction SourceField="P5"

 

ResultFormatString="{}{0:C0}" />

 

 

</telerik:GridViewDataColumn.AggregateFunctions>

　

 

 

</telerik:GridViewDataColumn>

 

 

<telerik:GridViewDataColumn Header="Apr"

 

DataMemberBinding="{Binding P6, Mode=TwoWay}"

 

DataFormatString="{}{0:C0}">

 

 

<telerik:GridViewDataColumn.AggregateFunctions>

 

 

<Data:SumFunction SourceField="P6"

 

ResultFormatString="{}{0:C0}" />

 

 

</telerik:GridViewDataColumn.AggregateFunctions>

　

 

 

</telerik:GridViewDataColumn>

 

 

<telerik:GridViewDataColumn Header="May"

 

DataMemberBinding="{Binding P7, Mode=TwoWay}"

 

DataFormatString="{}{0:C0}">

 

 

<telerik:GridViewDataColumn.AggregateFunctions>

 

 

<Data:SumFunction SourceField="P7"

 

ResultFormatString="{}{0:C0}" />

 

 

</telerik:GridViewDataColumn.AggregateFunctions>

 

 

</telerik:GridViewDataColumn>

 

 

<telerik:GridViewDataColumn Header="Jun"

 

DataMemberBinding="{Binding P8, Mode=TwoWay}"

 

DataFormatString="{}{0:C0}">

 

 

<telerik:GridViewDataColumn.AggregateFunctions>

 

 

<Data:SumFunction SourceField="P8"

 

ResultFormatString="{}{0:C0}" />

 

 

</telerik:GridViewDataColumn.AggregateFunctions>

　

 

 

</telerik:GridViewDataColumn>

 

 

<telerik:GridViewDataColumn Header="Jul"

 

DataMemberBinding="{Binding P9, Mode=TwoWay}"

 

DataFormatString="{}{0:C0}">

 

 

<telerik:GridViewDataColumn.AggregateFunctions>

 

 

<Data:SumFunction SourceField="P9"

 

ResultFormatString="{}{0:C0}" />

 

 

</telerik:GridViewDataColumn.AggregateFunctions>

　

 

 

</telerik:GridViewDataColumn>

 

 

<telerik:GridViewDataColumn Header="Aug"

 

DataMemberBinding="{Binding P10, Mode=TwoWay}"

 

DataFormatString="{}{0:C0}">

 

 

<telerik:GridViewDataColumn.AggregateFunctions>

 

 

<Data:SumFunction SourceField="P10"

 

ResultFormatString="{}{0:C0}" />

 

 

</telerik:GridViewDataColumn.AggregateFunctions>

　

 

 

</telerik:GridViewDataColumn>

 

 

<telerik:GridViewDataColumn Header="Sep"

 

DataMemberBinding="{Binding P11, Mode=TwoWay}"

 

DataFormatString="{}{0:C0}">

 

 

<telerik:GridViewDataColumn.AggregateFunctions>

 

 

<Data:SumFunction SourceField="P11"

 

ResultFormatString="{}{0:C0}" />

 

 

</telerik:GridViewDataColumn.AggregateFunctions>

　

　

 

 

</telerik:GridViewDataColumn>

 

 

<telerik:GridViewDataColumn Header="Oct"

 

DataMemberBinding="{Binding P12, Mode=TwoWay}"

 

DataFormatString="{}{0:C0}">

 

 

<telerik:GridViewDataColumn.AggregateFunctions>

 

 

<Data:SumFunction SourceField="P12"

 

ResultFormatString="{}{0:C0}" />

 

 

</telerik:GridViewDataColumn.AggregateFunctions>

　

　

 

 

</telerik:GridViewDataColumn>

 

 

<telerik:GridViewDataColumn Header="Active"

 

DataMemberBinding="{Binding IsActive}"

 

IsReadOnly="True" />

 

 

</telerik:RadGridView.Columns>

 

 

</telerik:RadGridView>

[Vlad]

Hello,

 Can you post more info about the grid version?

Best wishes,
Vlad
the Telerik team

[Thomas]

I am using 2011Q1

[Vlad]

Hello,

 Can you try Q1 2011 SP1 or even our just released Q2 2011?

Kind regards,
Vlad
the Telerik team

[Thomas]

Just updated to Q2 2011 and no cigar same beheviour.

[Yordanka]

Hi Thomas,

This is a known problem when the group descriptor is defined before the columns. It has been logged in our PITS system so you can track the issue status by following ID4383.
The aggregates will be shown correctly, if the group descriptor is defined after the definition of the columns. I hope this solution is acceptable for you.
 
All the best,
Yordanka
the Telerik team