此主题相关图片如下:87-1.jpg
此主题相关图片如下:87-3.jpg
两条记录的“是否提交”字段不一样,导致汇总后有重复的记录,如何只显示一个名字,然后金额汇总
Dim jb As New SQLGroupTableBuilder("统计表1","表b")
jb.AddTable("表B","名称","表a","第一列")
jb.Caption = "统计表1"
jb.Groups.AddDef("名称","名称","姓名")
jb.Groups.AddDef("第二列","第二列","账号")
jb.Groups.AddDef("第三列","第三列","银行")
jb.Groups.AddDef("是否提交","是否提交","是否提交")
jb.Totals.AddDef("金额","金额","合计费用")
jb.Filter = ""
jb.Build()
MainTable = Tables("统计表1")
Tables("窗口1_Table1").DataSource = DataTables("统计表1")