Server-side aggregates with grouping on Grid?

1 Answer 179 Views
Grid
Brian Vallelunga
Top achievements
Rank 1
Brian Vallelunga asked on 21 May 2021, 07:27 PM

Is it possible to perform server-side grouping/aggregates on a grid? I have several columns which are calculated percentages that need the raw data to accurately calculate averages.

Thanks

1 Answer, 1 is accepted

Sort by
0
Svet
Telerik team
answered on 26 May 2021, 01:31 PM

Hi Brian,

Generally, in order for the Grid to display grouped data properly its data should be a collection of GroupResults as demonstrated in the following article:

https://www.telerik.com/kendo-angular-ui/components/grid/grouping/

Indeed the server logic used to perform the actual grouping or any other server operations like filtering or sorting is considered a developer effort. The required Grid data operations can be applied to the data on the server using any custom approach. The data operations should be performed according to the current Grid State which holds information about the applied paging, grouping, soring and filtering.

If you are using ASP.NET Core or ASP.NET MVC then you can rely on the DataSourceRequest model binder and the ToDataSourceResult() method which process bulk data operations on the server:

https://www.telerik.com/kendo-angular-ui/components/data-query/mvc-integration/

In case further information is required for this case, please provide some more relevant details about the specific use - case scenario so that I can better understand the issue which you are facing. Thank you.

Regards,
Svetlin
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.

Tags
Grid
Asked by
Brian Vallelunga
Top achievements
Rank 1
Answers by
Svet
Telerik team
Share this question
or