如下分组统计提示错误:已有相同的键。不知道是错在哪里
Dim b1 As New SQLGroupTableBuilder("统计表1","员工周分析明细")
Dim dt1 As fxDataSource
b1.C
b1.Groups.AddDef("门店") '根据产品分组
b1.Groups.AddDef("营业员") '根据产品分组
b1.Totals.AddDef("销售金额","本周销售金额_实际完成") '对数量进行统计
b1.Filter = filter
dt1= b1.BuildDataSource()
Dim b5 As New SQLGroupTableBuilder("统计表5","员工周分析明细")
Dim dt5 As fxDataSource
b5.C
b5.Groups.AddDef("门店") '根据产品分组
b5.Groups.AddDef("营业员") '根据产品分组
b5.Groups.AddDef("单号") '根据产品分组
b5.Totals.AddDef("销售金额",AggregateEnum.max,"周大单金额") '对数量进行统计
b5.Filter = filter
dt5= b5.BuildDataSource()
Dim nms As String() = {"门店","营业员"}
dt1.combine(nms,dt5,nms)
Tables(e.Form.Name & "_table3").DataSource = dt1
[此贴子已经被作者于2016/12/8 18:52:51编辑过]