两个sqlGroupTableBuilder生成的统计表1和统计表2如何竖向拼接成一个统计表,该用什么方法啊?
即:统计表2的所有行放到统计表1的下方。
Dim bd113 As New sqlGroupTableBuilder("统计表1","情况表")
bd113.C
bd113.filter="编号 In ('" & str113 & "')"
Dim dt113 As fxDataSource
bd113.Groups.AddDef("公司缩写") '根据型号分组
bd113.Groups.AddDef("银行账户") '根据型号分组
bd113.Groups.AddDef("编号") '根据型号分组
bd113.Totals.AddExp("余额","isnull(申购金额,0)-isnull(赎回本金,0)") '对金额进行统计
dt113 = bd113.BuildDataSource()
Dim bd113 As New sqlGroupTableBuilder("统计表2","情况表")
bd113.C
bd113.filter="编号 In ('" & str113 & "')"
Dim dt113 As fxDataSource
bd113.Groups.AddDef("公司缩写") '根据型号分组
bd113.Groups.AddDef("银行账户") '根据型号分组
bd113.Groups.AddDef("编号") '根据型号分组
bd113.Totals.AddExp("余额","isnull(申购金额,0)-isnull(赎回本金,0)") '对金额进行统计
dt113 = bd113.BuildDataSource()
[此贴子已经被作者于2020/10/27 17:04:08编辑过]