Empty
HTML
<script src="http://cdn.kendostatic.com/2012.1.322/js/kendo.all.min.js"></script>
<link rel="stylesheet" href="http://cdn.kendostatic.com/2012.1.322/styles/kendo.common.min.css">
<link rel="stylesheet" href="http://cdn.kendostatic.com/2012.1.322/styles/kendo.default.min.css">
<div id="grid"></div>
JavaScript
$("#grid").kendoGrid({
dataSource: {
type: "odata",
transport: {
read: "http://demos.kendoui.com/service/Northwind.svc/Products"
},
pageSize: 7,
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: false,
groupable: true,
pageable: true,
columns: [
{
field: "ProductName",
title: "Product Name",
aggregates: "count",
footerTemplate: "Total Count: #=count#",
groupFooterTemplate: "Count: #=count#"},
{
field: "UnitPrice",
title: "Unit Price"},
{
field: "UnitsOnOrder",
title: "Units On Order",
aggregates: "average",
footerTemplate: "Average: #=average#",
groupFooterTemplate: "Average: #=average#"},
{
field: "UnitsInStock",
title: "Units In Stock",
aggregates: ["min", "max", "count"],
footerTemplate: "<div>Min: #= min #</div><div>Max: #= max #</div>",
groupHeaderTemplate: "Units In Stock: #= value # (Count: #= count#)"}
]
});