We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Grid Aggregate Sum only current page data NOT all data

Thread ID:

Created:

Updated:

Platform:

Replies:

148731 Nov 1,2019 03:57 AM UTC Jan 10,2020 12:14 PM UTC Blazor 6
loading
Tags: Grid
MaTaO
Asked On November 1, 2019 03:57 AM UTC

Hi,

I face the problem when I enable paging in Grid. The aggregation only group and sum data at the current page, not all records in the data source ie. total
I used blazor version 17.3.18.

Regards,
MaTaO

Renjith Singh Rajendran [Syncfusion]
Replied On November 4, 2019 12:53 PM UTC

Hi MaTaO,  

Greetings from Syncfusion support.  

Query: “ The aggregation only group and sum data at the current page, not all records in the data source 

We understand that you want to display the total grouped count in aggregates based on the total records in a dataSource. Currently we do not have support for your requirement. We need some more details to analyze the feasibility in implementing this requirement. So kindly share the details about your grid data source details such as screenshot or code example. 

Regards, 
Renjith Singh Rajendran. 


MaTaO
Replied On November 7, 2019 10:27 AM UTC

Hi Renjith,

Here is the screenshots base on Syncfusion.

page 1


page 2 


As you can see the group named "Condiments" has a total of 11 items in the data source that stay on a different page but the information in the aggregate template is the value of its page not the value of data source aggregation. What I want is an option to aggregate from the data source, not the page. Then display on the aggregation template. This might relate to the post: https://www.syncfusion.com/forums/148119/grouping-and-aggregate-display-group-key-in-ltgroupfootertemplategt due to I want to access to the key property in aggregation template in order to calculate from outside component then bind to the template with the mapping aggregation key.

I read the release note but did not find the related feature has been released.

Thanks

Vignesh Natarajan [Syncfusion]
Replied On November 8, 2019 12:28 PM UTC

Hi MaTaO, 
 
Thanks for the update.  
 
Query: “The aggregation only group and sum data at the current page, not all records in the data source ie. total 
 
Thank you for requesting this “Need to display total grouped record count in grouped record details.” feature and helping us define it. We are always trying to make our products better and feature requests like yours are a key part of our product growth efforts. We have added this feature request to our database. You can now track the current status of this feature request in this feedback. 
At the planning stage for every release cycle, we review all open features and identify features for implementation based on specific parameters including product vision, technological feasibility, and customer interest. We have considered this requirement for our 2019 Volume 4 release which is expected to be rolled out in the month of 2019.  
You can track the status of the feature and you can also contact us or request timeline through the below feedback  
Till then we appreciate your patience. 
 
Regards,
Vignesh Natarajan.
 


Vignesh Natarajan [Syncfusion]
Replied On November 27, 2019 05:54 AM UTC

Hi MaTaO,  
 
We are glad to inform that our latest Nuget package (17.3.0.29-beta) has been successfully rolled out. In this release, we have resolved the issue “Need to display total grouped record count in grouped record details”. Please find the latest Nuget package from below and also the release notes regarding the fixes we have included in this release.  
 
 
 
Kindly ensure that you have referred the latest version script and css as below  
 
  <link rel='nofollow' href="https://cdn.syncfusion.com/ej2/17.3.29/fabric.css" rel="stylesheet" /> 
 
 
Now you can achieve your requirement using DisablePageWiseAggregates property of GridGroupSettings.  
 
<EjsGrid DataSource="@Orders" AllowPaging="true" AllowGrouping="true" Height="400"> 
        <GridGroupSettings DisablePageWiseAggregates="true" Columns="@(new string[] {"CustomerID"})"></GridGroupSettings> 
. . . . . . . .. . .  
    </EjsGrid> 
 
Please get back to us if you have further queries. 
 
Regards, 
Vignesh Natarajan. 
 
 


Costa
Replied On January 9, 2020 11:58 PM UTC

Does not work (17.4.0.42)

Vignesh Natarajan [Syncfusion]
Replied On January 10, 2020 12:14 PM UTC

Hi Costa,  
 
Sorry for the inconvenience caused.  
 
In our 2019 Volume 4 release (17.4.0.39) ,we have done some major changes in our components to enhance the component and improve the performance. Due to this changes, there are some breaking changes in our component which we are being resolved in our successive releases. So we have considered this feature for our 2020 Volume 1 release which is expected to be rolled out in the second week of March 2020. 
 
Till then we appreciate your patience. 
 
Regards, 
Vignesh Natarajan.   


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon