老师,如果QualifiedInQty - MrpQty 的值大于等于0,这条记录就不进行统计,以下该如修改,谢谢了。
DataTables("ProdutionOrder").Load
Dim ra As New CrossTableBuilder("TempOpenPro",DataTables("ProdutionOrder"))
ra.HGroups.AddDef("InvCode")
ra.VGroups.AddDef("VTid")
ra.Totals.AddDef("MrpQty","MrpQty")
ra.Totals.AddDef("QualifiedInQty","QualifiedInQty")
ra.HorizontalTotal =True
ra.Build
MainTable = Tables("TempOpenPro")