[Solved] Columns aggregreating for all pages.

[ziyahan]

Hi All;
I am using server side paging and I set my grid to show column sum at the column`'s footer. However, it calculates the sum data for each page. I want to calculate it for all page at once and show it in footer.
Is there a solution to do this?

[Petur Subev]

Hello Emre,

Aggregates for the whole Grid is demonstrated in the following example here:

http://demos.telerik.com/kendo-ui/grid/aggregates

In the example above the Grid uses serverPaging set to false (so all the data) is available on the client.

Since in your case you probably use serverPaging set to true, you also need to enable serverAggregates and calculate those on the server.

http://docs.telerik.com/kendo-ui/api/javascript/data/datasource#configuration-aggregate
http://docs.telerik.com/kendo-ui/api/javascript/data/datasource#configuration-serverAggregates
http://docs.telerik.com/kendo-ui/api/javascript/data/datasource#configuration-schema.aggregates

Kind Regards,
Petur Subev
Telerik