此主题相关图片如下:无标题.png
如何按科目组合统计后,同品牌的应收项组在同一列?
Dim bd1 As New CrossTableBuilder("统计表1",DataTables("固定费用"))
Dim dt1 As fxDataSource
bd1.HGroups.AddDef("科目")
bd1.VGroups.AddDef("品牌","{0}_应收")
bd1.Totals.AddDef("应收金额")
dt1 = bd1.BuildDataSource()
Dim bd2 As New CrossTableBuilder("统计表2",DataTables("水电费用"))
Dim dt2 As fxDataSource
bd2.HGroups.AddDef("科目")
bd2.VGroups.AddDef("品牌","{0}_应收")
bd2.Totals.AddDef("待收金额")
dt2 = bd2.BuildDataSource()
dt1.Combine("科目",dt2,"科目")