Radgrid aggregate with pages

[חיה]

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
	57857	28
	6786876
	757575	10
	563757
	5775	3
	42545242	5	1,300
	7466386	20
	886786
		66	4,347
NEXT PAGE:
	24258525	10
	7878575
	88575757	10
		20	0

נרשמים has to be 86

not 66

 

 

[Doncho]

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

[חיה]

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]

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.