修改了一下,你看看是不是你想要的统计。参考着改一下。
Dim ary1() As String = {"款号", "条码号", "颜色", "尺码"}
Dim ary2() As String = {"款号", "条码号", "颜色", "尺码"}
Dim g As New GroupTableBuilder("统计表1", DataTables("盘点表"))
Dim dt1 As fxDataSource
g.Groups.AddDef("款号")
g.Groups.AddDef("条码号")
g.Groups.AddDef("颜色")
g.Groups.AddDef("尺码")
g.Totals.AddDef("实盘数","入库_件数")
dt1 = g.BuildDataSource()
'-------销售表 ------------(销售表)
Dim h As New GroupTableBuilder("统计表2", DataTables("销售表"))
Dim dt2 As fxdatasource
h.Groups.AddDef("款号")
h.Groups.AddDef("条码号")
h.Groups.AddDef("颜色")
h.Groups.AddDef("尺码")
'h.Groups.AddDef("销售日期","销售_销售日期")
h.Totals.AddDef("件数","销售_件数")
dt2 = h.BuildDataSource()
dt1.Combine(ary1,dt2,ary2)
Tables("汇总表 _Table1").DataSource = dt1 '将统计结果绑定到Table