This is a migrated thread and some comments may be shown as answers.

[Solved] ShowGroupFooters and ShowColumnFooters

4 Answers 198 Views

GridView

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

Josh Sprague asked on 14 Dec 2009, 05:46 PM

I am having trouble displying both group footers and column footers to show the sum of a column. Here is my code - column footers are working:

    
                    <telerikGridView:RadGridView  
        
                        x:Name="RadGridView1" Width="400" Height="350" 
        
                        AutoExpandGroups="True" AutoGenerateColumns="False" 
        
                        ShowGroupFooters="True" ShowColumnFooters="True">  
        
                        <telerikGridView:RadGridView.GroupDescriptors> 
        
                            <data:GroupDescriptor SortDirection="Descending" Member="CostType">  
        
                            </data:GroupDescriptor> 
        
                        </telerikGridView:RadGridView.GroupDescriptors> 
        
                        <telerikGridView:RadGridView.Columns> 
        
                            <telerikGridView:GridViewDataColumn  
        
                                Header="Cost Date" DataMemberBinding="{Binding CostDate}" Width="150" /> 
        
                            <telerikGridView:GridViewDataColumn  
        
                                Header="Cost Amount" DataMemberBinding="{Binding CostAmount}" Width="150">  
        
                                <telerikGridView:GridViewDataColumn.AggregateFunctions> 
        
                                <data:SumFunction  
        
                                    SourceField="CostAmount" ResultFormatString="{}{0:C}" Caption="Total: " /> 
        
                                </telerikGridView:GridViewDataColumn.AggregateFunctions> 
        
                            </telerikGridView:GridViewDataColumn> 
        
                        </telerikGridView:RadGridView.Columns> 
        
                    </telerikGridView:RadGridView>

Can someone show me how to sum up the CostAmount column and display in group footer as well?

4 Answers, 1 is accepted

answered on 17 Dec 2009, 03:01 PM

Hello Josh Sprague,

It seems you have hit a bug in RadGridView . There is a known issue - when initially groupped , RadGridView will not display the aggregate results in the group footer.
Please excuse us for the inconvenience caused. We are already working on the solving the problem and will provide you with the fixed binaries as soon as it is ready ( I hope in a few days) .

I will keep you updated.

Sincerely,
Pavel Pavlov
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

answered on 21 Jan 2010, 07:29 PM

This doesn't seem to be fixed in the Q3 SP2 release. Can you confirm?

I'm attempting to persist the grid settings to local storage and then reload them. Everything works great except for the aggregate totals when there are groups (the totals don't display for the group).
I've tried setting the aggregate functions for the GroupDescriptor before and after the grid load. I've also tried just raising the GridLoading event and sending the GroupDescriptor with and without the aggregate functions included within the descriptor.

Thanks
-Brendon