Dim b As New SQLGroupTableBuilder("客户销售统计","Mainsale“)
b.C
b.AddTable("Mainsale","RCId","Detailesale","RCId")
b.Filter = "{Mainsale}.adddate >= '2020-11-19'And {Mainsale}.adddate <= '2020-11-19' "
b.Groups.AddDef("{Mainsale}.adddate",DateGroupEnum.Year,"年") '添加日期列用于分组,并用"年"代替原名称
b.Groups.AddDef("{Mainsale}.adddate","月") '添加日期列用于分组,并用"月"代替原名称
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 '生成统计表
为什么会提示adddate列不明确？
加好友 
发短信
Post By：2020/11/24 23:29:00 [只看该作者]
