Radgrid aggregate with pages

1 Answer 26 Views
Grid
חיה
Top achievements
Rank 1
חיה asked on 14 Nov 2021, 05:48 AM | edited on 18 Nov 2021, 01:07 PM

I created a grouped by radgrid with pagerstyle 10,

I added sum in footer,

but Sum is calculated for each 10 records.. I would like to see the sum just in end of group.

The sum is not by group, it's by page, how to make it by group?

<consist:ConsistGenericGrid ID="grData7" runat="server" ShowFooter="false" AllowSorting="false" DefaultSort="false" Visible="false"

                    OnNeedDataSource="grData7_NeedDataSource" OnPreRender="grData7_PreRender" OnItemDataBound="grData7_ItemDataBound">

                    <ClientSettings>

                        <ClientEvents OnColumnResized="telerik_ext.OnGridColumnResized" />

                    </ClientSettings>

                    <MasterTableView ShowGroupFooter="true" AllowMultiColumnSorting="true" ShowFooter="false">

                        <GroupByExpressions>

                            <telerik:GridGroupByExpression>

                                <GroupByFields>

                                    <telerik:GridGroupByField FieldName="GR" HeaderText=" " HeaderValueSeparator=" "></telerik:GridGroupByField>

                                </GroupByFields>

                                <SelectFields>

                                    <telerik:GridGroupByField FieldName="GR " HeaderText="קבוצת" HeaderValueSeparator=" "></telerik:GridGroupByField>

                                  </SelectFields>

                            </telerik:GridGroupByExpression>

                        </GroupByExpressions>

                    </MasterTableView>

                    <GroupingSettings ShowUnGroupButton="false" RetainGroupFootersVisibility="true" GroupContinuesFormatString="" GroupContinuedFormatString="" GroupSplitDisplayFormat=""></GroupingSettings>

 

                </consist:ConsistGenericGrid>

 

 זהותנרשמים
 קבוצת A  
 24252452 1,547
 2424245 1,500
 5785728 
 6786876  
 75757510 
 563757  
 57753 
 425452425     1,300
 746638620 
 886786  
  664,347
    
NEXT PAGE:   
 2425852510 
 7878575  
 8857575710 
  200

נרשמים has to be 86

not 66

 

 

1 Answer, 1 is accepted

Sort by
0
Doncho
Telerik team
answered on 17 Nov 2021, 02:22 PM

Hello,

Please refer to the Aggregates with Paging Enabled section of our Group Footers article.

In short, If you want to include all group records in the summarized calculation info you can set the IgnorePagingForGroupAggregates property in the GroupingSettings to true:

<telerik:RadGrid ID="RadGrid1" runat="server" ...>
    <GroupingSettings IgnorePagingForGroupAggregates="true"
Note that LINQ expressions must be enabled in order for the IgnorePagingForGroupAggregates to have an effect. The EnableLinqExpressions property is enabled by default and there is no need to set it to True explicitly.

Please let me know if any further questions come up.

Kind regards,
Doncho
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

חיה
Top achievements
Rank 1
commented on 18 Nov 2021, 01:11 PM

Thanks!

It's probably not supprted in my telerik version (2015.1.401.35)

Since when is it supprted? Or- Which version is recommended for ASP.NET framework?

Doncho
Telerik team
commented on 19 Nov 2021, 01:04 PM

Yes, you are right. This property is included with version 2015.2604 - UI for ASP.NET AJAX Q2 2015 Beta (version 2015.2.604). So you will need to update to be able to leverage it.

We recommend updating Telerik controls to our latest versions to take advantage of all the new controls, useful features, and fixes provided since 2015. Yet, upgrading to R1 2020 at least is highly recommended as it will provide safety to known vulnerabilities like the Allows JavaScriptSerializer Deserialization.

 

Tags
Grid
Asked by
חיה
Top achievements
Rank 1
Answers by
Doncho
Telerik team
Share this question
or