Dim bd1 As New SQLCrossTableBuilder("销售明细","t_rm_saleflow")
bd1.AddTable("t_rm_saleflow","item_no","t_bd_item_info","item_no")
bd1.AddTable("t_bd_item_info","item_clsno","t_bd_item_cls","item_clsno")
bd1.VGroups.AddDef("item_clsname")
bd1.HGroups.AddDef("oper_date",DateGroupEnum.Year,"年") '添加日期列用于分组,并用"年"代替原名称
bd1.HGroups.AddDef("oper_date","月")
bd1.Totals.AddDef("sale_qnty","数量")
bd1.Totals.AddExp("总吊牌价","sale_qnty * [source_price]")
以上有三个问题:
1：bd1.AddTable 是inner join能不能使用left join
2：bd1.AddTable("t_bd_item_info","item_clsno","t_bd_item_cls","item_clsno")
"t_bd_item_info","item_clsno"的"item_clsno"我想substring(1.4)不知道怎么写
3：bd1.Totals.AddDef("sale_qnty","数量")出来的数量，有好几位小数。需要取整
加好友 
发短信
Post By：2021/5/5 11:39:00 [只看该作者]
