效果:
效果:
获取表格数据
function getDataSource(){ return new kendo.data.DataSource({ data:reportData, aggregate: [ { field: "member", aggregate: "sum" }, { field: "useMount", aggregate: "sum" }, { field: "appCustomer", aggregate: "sum" }, { field: "appMember", aggregate: "sum" }, { field: "sellCard", aggregate: "sum" }, { field: "prepaid", aggregate: "sum" }, { field: "orderGross", aggregate: "sum" }, { field: "order", aggregate: "sum" } ], pageSize:15 }) }合计行:
{ field:"one", title:'1', width:120, footerTemplate: "<div class='bold'>合计:<span class='mgle5' id='allStore'></span></div>" }对应需要合计的行:
{ field:"one", title:'1', width:100, footerTemplate: "<span class='foot_total' id='member'></span>" }合计行函数:
dataBound: function () { var that=this; //计算合计 $('.k-footer-template span.foot_total').each(function (index) { var field=that.dataSource.aggregate()[index].field; var value = that.dataSource.aggregates()[field].sum; $(this).html(value.toFixed(2)); }) }, }).data('kendoGrid');效果: