Access group aggregates in group header in razor

[tarnegur]

Hi.

I have a grid written in razor, using server data source (not ajax) with grouping and aggregated columns on the group.

 Now, how can I access all columns aggregates in the GroupHeaderTemplate method?

[Vladimir Iliev]

Hello Stas,

The GroupHeaderTemplate contains local variable "item" which contains all available aggregates for current column. Please check the example below:

columns.Bound(p => p.UnitsInStock)
    .GroupHeaderTemplate(@<text>
                @item.Title: @item.Key
           (Count: @item.Count) (UnitsOnOrder Average: @item.Average)
                </text>);})

.DataSource(dataSource => dataSource
    .Server()
    .Aggregates(aggregates =>
    {
        aggregates.Add(p => p.UnitsInStock).Min().Max().Count();
        aggregates.Add(p => p.UnitsOnOrder).Average();

Regards,
Vladimir Iliev
Telerik

 

 

[tarnegur]

Hello Vladimir.

Thank you for your answer. I know this, but I need to access ALL columns aggregates.

How can I access them in one group header?

.Aggregates(groupAggregates =>
              {
                  groupAggregates.Add(x => x.Amount).Sum();
                  groupAggregates.Add(x => x.Net).Sum();
                  groupAggregates.Add(x => x.Gros).Sum();
                  groupAggregates.Add(x => x.Total).Sum();
              })

@item.Sum will be only the aggregate of one of them.

[Vladimir Iliev]

Hello Stas,

Please note that you can't access the other fields duplicated aggregates (in server binding mode) as they are overridden by the current field aggregate. If you need to access all of the available aggregates then you should switch to ajax-binding mode.

Regards,
Vladimir Iliev
Telerik

 

 

[tarnegur]

Do you have an example, how to make it in an ajax bound grid?

[Dimo]

Hello Stas,

There is no way to access all aggregate values from all column directly from inside a specific column's group header template, however, you can use script expressions inside the template to get the Grid object, then the Grid dataSource and obtain all aggregate values by using the DataSource API.

Here is a simplified example, based on the Aggregates demo. The result is shown on the attached screenshot.

http://demos.telerik.com/aspnet-mvc/grid/aggregates

http://docs.telerik.com/kendo-ui/framework/templates/overview

http://docs.kendoui.com/api/framework/datasource#methods-aggregates

@(Html.Kendo().Grid<Kendo.Mvc.Examples.Models.ProductViewModel>()
    .Name("Grid")
    .Columns(columns =>
    {
        columns.Bound(p => p.UnitsInStock)
            .ClientGroupHeaderTemplate("Units In Stock: #= value # (Count: #= count#) #= kendo.stringify(grid.dataSource.aggregates()) #")
            .ClientFooterTemplate("<div>Min: #= min #</div><div>Max: #= max #</div>");
    })
)

<script>

    var grid;

    $(function () {
        grid = $("#Grid").data("kendoGrid");
    });

</script>

Regards,
Dimo
Telerik