If Filter > "" Then
Dim b As New SQLGroupTableBuilder("统计表1","表D")
b.C
b.FromServer = True
'b.filter = filter & " And 支付方式 Like '预付%'" '' 这里是怎么错了.....................:???
b.addtable("表D","编号","表E","编号")
b.Groups.AddDef("{表D}.编号") '根据产品分组
b.groups.adddef("IC代码") ‘ b.groups.adddef("IC代码", Gettype(Double)) 不能改成这样
b.Totals.AddDef("金额") '对数量进行统计
b.Groups.AddDef("客户姓名")
b.Groups.AddDef("{表E}.支付方式")
b.Totals.AddDef("{表D}.编号",AggregateEnum.Count,"次数")
Forms("表D").controls("Table1").Table.Datasource = b.BuildDataSource
forms("表D").controls("table1").Table.grid.Cols("IC代码").width = 120
DataTables("表D_Table1").DataCols("IC代码").SetFormat("00.000000") ' 这里小数数值显示不对
forms("表D").controls("table1").Table.filter = "支付方式 like '预付%'"
DataTables("表D_Table1").load()
End If
[此贴子已经被作者于2018/12/29 21:53:16编辑过]