Empty

by valchev

HTML

<link rel="stylesheet" href="http://cdn.kendostatic.com/2012.2.710/styles/kendo.common.min.css">
<link rel="stylesheet" href="http://cdn.kendostatic.com/2012.2.710/styles/kendo.default.min.css">
<script src="http://cdn.kendostatic.com/2012.2.710/js/kendo.all.min.js"></script>
<div id="grid"></div>

JavaScript

$("#grid").kendoGrid({
    dataSource: {
        type: "odata",
        transport: {
            read: "http://demos.kendoui.com/service/Northwind.svc/Products"
        },
        pageSize: 50,
        group: {
            field: "UnitsInStock",
            aggregates: [
                {
                field: "ProductName",
                aggregate: "count"},
            {
                field: "UnitPrice",
                aggregate: "sum"},
            {
                field: "UnitsOnOrder",
                aggregate: "average"},
            {
                field: "UnitsInStock",
                aggregate: "count"}
            ]
        },

        aggregate: [{
            field: "ProductName",
            aggregate: "count"},
        {
            field: "UnitPrice",
            aggregate: "sum"},
        {
            field: "UnitsOnOrder",
            aggregate: "average"},
        {
            field: "UnitsInStock",
            aggregate: "min"},
        {
            field: "UnitsInStock",
            aggregate: "max"}]
    },
    sortable: true,
    scrollable: true,
    height: 300,
    groupable: true,
    pageable: true,
    dataBound: function(e) {
        
        //set the initial scroll
        $("#grid").find(".k-grid-footer-wrap")
            .scrollLeft($("#grid").find(".k-grid-content").scrollLeft());
        
        this.content.bind('scroll', function () {
            $("#grid").find(".k-grid-footer-wrap").scrollLeft(this.scrollLeft);
        });
    },
    columns: [
        {
        field: "ProductName",
        title: "Product Name",
        aggregates: "count",        
        footerTemplate: "Total Count: #=count#",
        groupFooterTemplate: "Count: #=count#",
        width: "300px"},
    {
        field: "UnitPrice",
        title: "Unit Price",
        width: "300px"},
    {
        field: "UnitsOnOrder",
        title: "Units On Order",
        aggregates: "average",  
        footerTemplate: "Average: #=average#",
      ...