主题：统计表应用问题

Dim b As New SQLGroupTableBuilder("装坯数量","日报表")
b.Filter = "工序='" & "干压生产线装坯" & "' and 生产状态='" & "正常生产" & "'"
b.Groups.AddDef("联号")
b.Totals.AddDef("生产数","装坯生产数")
b.Totals.AddDef("正品数","装坯正品数")
b.Totals.AddExp("装坯合格率","正品数")
b.Build

Dim b1 As New SQLGroupTableBuilder("成型数量","日报表")
b1.Filter = "工序='" & "干压生产线成型" & "' and 月份='" & 201310 & "' and 生产状态='" & "正常生产" & "'"
b1.Groups.AddDef("工序")
b1.Groups.AddDef("生产日期",DateGroupEnum.none)
b1.Groups.AddDef("姓名")
b1.Groups.AddDef("月份")
b1.Groups.AddDef("{日报表}.联号")
b1.Groups.AddDef("{日报表}.规格型号")
b1.Totals.AddDef("生产数")
b1.Totals.AddExp("外观奖励","正品数")
b1.Build

Dim b2 As New SQLGroupTableBuilder("成型激励报表","成型数量")
b2.AddTable("成型数量","联号","装坯数量","联号")
b2.Groups.AddDef("{成型数量}.工序")
b2.Groups.AddDef("{成型数量}.联号")
b2.Groups.AddDef("生产日期",DateGroupEnum.none)
b2.Groups.AddDef("姓名")
b2.Groups.AddDef("月份")
b2.Groups.AddDef("规格型号")
b2.Groups.AddDef("生产数")
b2.Groups.AddDef("装坯生产数")
b2.Groups.AddDef("装坯正品数")
b2.Groups.AddDef("装坯合格率")
b2.Groups.AddDef("外观奖励")
b2.Build
MainTable = Tables("成型激励报表")