Dim g As New SQLGroupTableBuilder("统计表1","订单明细表")
g.C
g.Groups.AddDef("日期",DateGroupEnum.Year,"年度")
g.Groups.AddDef("日期", "月份")
g.Totals.AddDef("编号", AggregateEnum.Count,"总piao数")
g.Totals.AddExp("订单","case when 是否订购='已订购' then 1 else 0 end","已订购_piao数")
g.Totals.AddExp("日期","case when 是否付款=‘已付款’ then 1 else 0 end","已付款_piao数")
g.VerticalTotal = True
g.SubTotal = True
g.FromServer = True
Tables("订单统计_table1").DataSource = g.BuildDataSource()
Dim nms() As String = {"已订购",“已付款”}
For Each nm As String In nms
DataTables("订单统计_table1").DataCols.Add(nm & "_占比",Gettype(Double),nm & "_piao数/总piao数")
Tables("订单统计_table1").Cols(nm & "_占比").Move(Tables("订单统计_table1").Cols(nm & "_piao数").Index + 1)
Next
请教一下,上面的代码问题在哪里。。添加列“占比”的时候 nm & "_piao数/总piao数" , 系统提示说 找不到 已订购_piao数,和已付款_piao数,无法统计占比。
[此贴子已经被作者于2016/9/10 13:43:16编辑过]