Aggregates when using BindTo

[Daniel Knoll]

Hi,

I know how to specify aggregates when using a DataSource to populate the grid.

But how do I define aggregates when I'm populating the Grid using BindTo?

I want a Sum row at the bottom of this Grid:

@(Html.Kendo().Grid<Models.AgentLeaderData>()

        .Name("AgentLeaderData")

        .Columns(col =>

        {

            col.Bound(p => p.AgentName);

            col.Bound(p => p.Revenue).HtmlAttributes(new { style = "text-align:right" });

        })

         

        .BindTo(Model.AgentLeaderData)

)

[Daniel]

Hello,

In server binding mode the aggregates should specified the same way - through the DataSource Aggregates method. To show the sum in the footer you should use a FooterTemplate e.g.

.Columns(col =>
{
    col.Bound(p => p.AgentName);
    col.Bound(p => p.Revenue).FooterTemplate(@<text>Sum: @item.Sum</text>).HtmlAttributes(new { style = "text-align:right" });
})
.DataSource(dataSource => dataSource
    .Server()
    .Aggregates(aggregates =>
    {
        aggregates.Add(p => p.Revenue).Sum();
    })

We have a server aggregates demo available in the examples project included with the installation.

Regards,
Daniel
the Telerik team

[Daniel Knoll]

That's working. Thank you very much.

[Surya]

Hello, running into the same issue but in .NET Core .. Server is not valid. Could you please let me know what'd work

[Mihaela]

Hi Surya, 

Generally, the Telerik UI for ASP.NET Core Grid does not support server binding as available in Telerik UI for ASP.NET MVC. You can find the available types of data binding in the following section of the Grid documentation:

https://docs.telerik.com/aspnet-core/html-helpers/data-management/grid/binding/overview