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

Group footer's aggregate values not shown

32 Answers 469 Views

GridView

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

project30 asked on 18 Jun 2010, 09:47 PM

screenshot-2.png

screenshot-1.png

I'm displaying a group's footer and I wish to display aggregate values in it (see first image attached). When I use the drag/drop feature, everything's fine. However, when I use the drop-down as in image 2 attached, the aggregate values are not displayed in each group's footer (however, it's still displayed in the grid's footer itself).

Here's the code that's executed when the user selects a value in the drop down :

                            private void CreateGroup(string member, string displayContent)         
                    {         
                        this.RosterRecordGrid.GroupDescriptors.Clear();         
                     
                        var descriptor = new Telerik.Windows.Data.GroupDescriptor();         
                        descriptor.Member = member;         
                        descriptor.SortDirection = ListSortDirection.Ascending;         
                        descriptor.DisplayContent = displayContent;         
                     
                        this.RosterRecordGrid.GroupDescriptors.Add(descriptor);         
                    }         
                     

Here's the xaml:

                            <pc:CustomDataGrid         
                        Grid.Row="3"         
                        x:Name="RosterRecordGrid"                          
                        ItemsSource="{Binding Path=Entities}"                          
                        AutoExpandGroups="True"         
                        AutoGenerateColumns="False"          
                        FrozenColumnCount="7"          
                        CanUserFreezeColumns="False"          
                        CanUserDeleteRows="False"          
                        CanUserInsertRows="False"          
                        CanUserReorderColumns="False"          
                        CanUserResizeColumns="False"          
                        CanUserSortColumns="False"         
                        ShowColumnFooters="True"         
                        ShowGroupFooters="True"         
                        ShowInsertRow="False"         
                        IsBusy="{Binding BusyIndicator.IsBusy}">         
                        <r:RadGridView.Columns>         
                            <r:GridViewDataColumn Header="Client" DataMemberBinding="{Binding Path=ClientFullName}" >         
                                <r:GridViewDataColumn.AggregateFunctions>         
                                    <telerik:CountFunction ResultFormatString="{}Total clients: {0}" />         
                                </r:GridViewDataColumn.AggregateFunctions>         
                            </r:GridViewDataColumn>         
                            <r:GridViewDataColumn Header="Service" DataMemberBinding="{Binding Path=ServiceUuid, Converter={StaticResource lookupConverter}, ConverterParameter=Services}">         
                            </r:GridViewDataColumn>         
                            <r:GridViewDataColumn Header="Fund Identifier" DataMemberBinding="{Binding Path=FundIdentifierUuid, Converter={StaticResource lookupConverter}, ConverterParameter=FundIdentifiers}">         
                            </r:GridViewDataColumn>         
                            <r:GridViewDataColumn Header="Subservice" DataMemberBinding="{Binding Path=SubserviceUuid, Converter={StaticResource lookupConverter}, ConverterParameter=Subservices}">         
                            </r:GridViewDataColumn>         
                            <r:GridViewDataColumn Header="Place of Service" DataMemberBinding="{Binding Path=PlaceOfServiceCode, Converter={StaticResource lookupConverter}, ConverterParameter=PlacesOfService}">         
                            </r:GridViewDataColumn>         
                            <r:GridViewDataColumn Header="Unit Price" DataMemberBinding="{Binding Path=UnitPrice}">         
                            </r:GridViewDataColumn>         
                            <r:GridViewDataColumn Header="Total Units" DataMemberBinding="{Binding Path=TotalUnits}" CellTemplateSelector="{StaticResource selector}">         
                                <r:GridViewDataColumn.AggregateFunctions>         
                                    <telerik:SumFunction SourceField="TotalUnits" ResultFormatString="{}Total units: {0}" />         
                                </r:GridViewDataColumn.AggregateFunctions>         
                            </r:GridViewDataColumn>         
                        </r:RadGridView.Columns>         
                    </pc:CustomDataGrid>         
                     

32 Answers, 1 is accepted

answered on 22 Jun 2010, 08:13 AM

Hi project30,

This is the expected behavior, as the column aggregates are shown only when grouping by the UI. In your project when adding a group descriptor programmatically at run time, you need also to define the column's functions in the code - in your case in the method CreateGroup. For example:

CountFunction f = new CountFunction();

( ( GridViewDataColumn )this.radGridView.Columns[ "ID" ] ).AggregateFunctions.Add( f );

Kind regards,
Maya
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

answered on 23 Jun 2010, 02:08 AM

No... It's not working. I did like you said, and the footer is still absent (with or without the call to Clear):

                            private void CreateGroup(string member, string displayContent)         
                    {         
                        this.RosterRecordGrid.GroupDescriptors.Clear();         
                     
                        var descriptor = new Telerik.Windows.Data.GroupDescriptor();         
                        descriptor.Member = member;         
                        descriptor.SortDirection = ListSortDirection.Ascending;         
                        descriptor.DisplayContent = displayContent;         
                        this.RosterRecordGrid.GroupDescriptors.Add(descriptor);         
                     
                        var column = this.RosterRecordGrid.Columns["TotalUnitsColumn"];         
                        //column.AggregateFunctions.Clear();         
                        var function = new SumFunction() { SourceField = "TotalUnits", ResultFormatString = "{}Total units: {0}" };         
                        column.AggregateFunctions.Add(function);         
                    }         
                     

Note that the GroupDescriptor works as expected.

answered on 23 Jun 2010, 02:47 PM

Hello project30,

You need to add your function to the AggregateFunctions of the GroupDescriptor

private void CreateGroup(string member, string displayContent)

{ ...

var descriptor = new Telerik.Windows.Data.GroupDescriptor();

var function = new SumFunction() { SourceField = "TotalUnits", ResultFormatString = "{}Total units: {0}" };

column.AggregateFunctions.Add(function);

descriptor.AggregateFunctions.Add(function);

}

Regards,
Maya
the Telerik team

answered on 07 Jul 2010, 12:29 PM

The field3 is numeric value. We need to display the sum aggregate of the field3 in the group footer. The grid is grouped by the field1. The code for Grouping and the XAML is provided below.

    
                    public void ChangeGroup() 
        
                    { 
        
                        // Do not show the grouped column in the view 
        
                        RadGridView1.Columns[0].IsVisible = false; 
        
                        RadGridView1.GroupDescriptors.Clear(); 
        
                        var descriptor = new Telerik.Windows.Data.GroupDescriptor(); 
        
                        descriptor.Member = "field1"; 
        
                        descriptor.DisplayContent = "field1"; 
        
                        this.Dispatcher.BeginInvoke(new Action(() => this.RadGridView1.GroupDescriptors.Add(descriptor)));  
        
                        var column = this.RadGridView1.Columns[2]; 
        
                        var function = new SumFunction() { SourceField = "field3", ResultFormatString = "{}{0}" }; 
        
                        column.AggregateFunctions.Add(function); 
        
                        descriptor.AggregateFunctions.Add(function); 
        
                    }

    
                    <telGrid:RadGridView x:Name="RadGridView1" AutoGenerateColumns="False" CanUserResizeColumns="False" 
        
                                                     CanUserReorderColumns="True" AutoExpandGroups="True" RowDetailsVisibilityMode="VisibleWhenSelected" 
        
                                                     ShowGroupPanel="True" IsFilteringAllowed="False" RowIndicatorVisibility="Collapsed" CanUserFreezeColumns="False" AreRowDetailsFrozen="False" 
        
                                                     ShowGroupFooters="True" 
        
                                                     Background="White" VerticalAlignment="Top" Margin="0 10 0 0" Grid.ColumnSpan="2"> 
        
                        <telGrid:RadGridView.Columns> 
        
                            <telGrid:GridViewDataColumn DataMemberBinding="{Binding field1}" Header="field1" IsReadOnly="True" Width="285" IsVisible="False"> 
        
                            </telGrid:GridViewDataColumn> 
        
                            <telGrid:GridViewDataColumn DataMemberBinding="{Binding field2}" Header="field2" IsReadOnly="True" Width="285"></telGrid:GridViewDataColumn> 
        
                            <telGrid:GridViewDataColumn DataMemberBinding="{Binding field3}" Header="field3" IsReadOnly="True" Width="135"> 
        
                                <telGrid:GridViewDataColumn.AggregateFunctions> 
        
                                    <telData:SumFunction SourceField="field3" /> 
        
                                </telGrid:GridViewDataColumn.AggregateFunctions> 
        
                            </telGrid:GridViewDataColumn> 
        
                            <telGrid:GridViewDataColumn DataMemberBinding="{Binding field4}" Header="field4" IsReadOnly="True" Width="135"></telGrid:GridViewDataColumn> 
        
                        </telGrid:RadGridView.Columns> 
        
                    </telGrid:RadGridView>

Thanks

Karthik

answered on 18 Apr 2011, 01:10 PM

emptygroupfooter.jpg

I don't know what I'm doing wrong but here's the entire code along with a screenshot showing the result on IE 9

void MainPage_Loaded(object sender, RoutedEventArgs e)

{

Expression.Blend.SampleData.PrestiluxData.PrestiluxData p = new Expression.Blend.SampleData.PrestiluxData.PrestiluxData();

rgvTest.ItemsSource = p.Collection;

rgvTest.ShowGroupFooters = true;

rgvTest.AutoGenerateColumns = true;

rgvTest.AutoGeneratingColumn += new EventHandler<GridViewAutoGeneratingColumnEventArgs>(rgvTest_AutoGeneratingColumn);

rgvTest.GroupDescriptors.Add(new Telerik.Windows.Data.GroupDescriptor() { DisplayContent = "Test", Member = "Property1" });

rgvTest.AutoExpandGroups = true;

}

void rgvTest_AutoGeneratingColumn(object sender, Telerik.Windows.Controls.GridViewAutoGeneratingColumnEventArgs e)

{

GridViewDataColumn column = e.Column as GridViewDataColumn;

if (column.DataType == typeof(double))

column.DataFormatString = "{0:C2}";

if (e.Column.UniqueName == "Property2")

{

var descriptor = new Telerik.Windows.Data.GroupDescriptor();

var function = new SumFunction() { SourceField = e.Column.UniqueName, ResultFormatString = "{0}" };

column.AggregateFunctions.Add(function);

descriptor.AggregateFunctions.Add(function);

}

answered on 18 Apr 2011, 01:55 PM

Hello Marc Roussel,

if (e.Column.UniqueName == "Property2")

{

var descriptor = new Telerik.Windows.Controls.GridView.ColumnGroupDescriptor();

descriptor.Column = column;

var function = new SumFunction() { SourceField = e.Column.UniqueName, ResultFormatString = "{0}" };

column.AggregateFunctions.Add(function);

}

Greetings,
Yavor Georgiev
the Telerik team

answered on 09 Jun 2011, 06:48 PM

Hi,

I'm also experiencing the same behavior where my group footers are not rendering. If i manually group/ungroup it, the aggregates will come back.

I have updated my telerik to the newest version at this time: 2011.1.419.1040

I've also tried using the ColumnGroupDescriptors with no avail.

I add the GroupDescriptors during the initialization of my view (in the constructor).

CounterPartyExposureView.GroupDescriptors.Clear();

ColumnGroupDescriptor gd = new ColumnGroupDescriptor();

gd.Column = CounterPartyExposureView.Columns[4];

CounterPartyExposureView.GroupDescriptors.Add(gd);

I have also tried grouping in the xaml instead and played around with a few things.

Tony

answered on 13 Jun 2011, 08:33 AM

RadGridView-SL4-AR-28.zip

Hello tony,

Could you please check the attached sample project where the aggregates are shown correctly? Let me know in case I have missed something and the scenario for reproducing the problem is different.

Best wishes,
Yordanka
the Telerik team

answered on 14 Jul 2011, 03:50 PM

groupfooters.png

I'm having the same problem. Oddly it works elsewhere but with a different type of datasource (QueryableCollectionView) and a RadDataPager. The one that doesn't work just uses an ObvervableCollection. The top level footers render fine, as do the items in the group row. It's the same whether I do it manually or via code (using a ColumnGroupDescriptor).

The only other difference I can think of is that some of the fields are editable in the one that doesn't work, but I can't see why that would be a problem.

I've attached a screenshot.

PS. I'm using 2011.1.419.1040, Q2 doesn't seem to have changed this but does seem to have broken other grouping related stuff.

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Group footer's aggregate values not shown

32 Answers, 1 is accepted