Dim sql As String
sql=“”
Dim bm As String = "统计表1"
Dim b As New GroupTableBuilder(bm,sql)
b.ConnectionName=Functions.Execute("返回数据源")
b.Groups.AddDef("产品名称")
b.Totals.AddExp("库龄分布_60天以下","IIF(库龄<60,1,0)")
b.Totals.AddExp("库龄分布_60天以上","IIF(库龄>=60 and 库龄<120,1,0)")
b.Totals.AddExp("库龄分布_120天以上","IIF(库龄>=120 and 库龄<150,1,0)")
b.Totals.AddExp("库龄分布_150天以上","IIF(库龄>=150 and 库龄<180,1,0)")
b.Totals.AddExp("库龄分布_180天以上","IIF(库龄>=180,1,0)")
b.Build
MainTable = Tables(bm)
使用这个代码生成表的时候 只有一个产品名称列 是什么原因
加好友 
发短信
Post By：2019/5/23 18:15:00 [显示全部帖子]
