Dim b As New SQLGroupTableBuilder("客户销售统计","Mainsale")
b.C
b.AddTable("Mainsale","RCId","Detailesale","RCId")
b.Filter = "{Mainsale}.adddate >= '2020-11-22' And {Mainsale}.adddate <= '2020-11-22' "
b.Groups.AddDef("{Mainsale}.adddate",DateGroupEnum.Year,"年") '添加日期列用于分组,并用"年"代替原名称
b.Groups.AddDef("{Mainsale}.adddate",DateGroupEnum.Month,"月")
b.Groups.AddDef("{Mainsale}.adddate",DateGroupEnum.day,"日") '添加产品列用于分组
b.Groups.AddDef("{Mainsale}.RCId","系统编号")
b.Groups.AddDef("{Mainsale}.Name","客户名称")
b.Totals.AddDef("{Mainsale}.expressfee","运费") '添加数量列用于统计
b.Totals.AddDef("{Detailesale}.total","销售金额")
b.Build '生成统计表
还是出现了dddate列名不明确。
如果不按adddate 日期列分组则没有任何问题!
[此贴子已经被作者于2020/11/25 10:19:34编辑过]