此主题相关图片如下:微信图片_20240327144307.png

Dim g As New CrossTableBuilder("统计表2", DataTables("产值登记表"))
g.HGroups.AddDef("归属")
g.HGroups.AddDef("编号")
g.HGroups.AddDef("编码")
g.VGroups.AddDef("已开piao", "已开piao|未开piao")
g.Totals.AddDef("应收金额", "应收金额")
g.Build()
MainTable = Tables("统计表2")
问题如图,大神帮忙看下,帮忙写下正确的代码,谢谢了!
Dim g As New SQLGroupTableBuilder("统计表2", ("产值登记表"))
g.HGroups.AddDef("归属")
g.HGroups.AddDef("编号")
g.HGroups.AddDef("编码")
g.Totals.AddExp("已收款","iif(已收款=true,应收金额,0)")
g.Totals.AddExp("未收款","iif(已收款=false,应收金额,0)")……
g.Build()
MainTable = Tables("统计表2")

此主题相关图片如下:微信截图_20240327151314.png