有个分组统计,代码如下 ,单价不要合计数, 怎么写代码?Dim filter1 As String
filter1="客户名称= '" & e.Form.Controls("ComboBox1").value & "'" & " And 加工日期 >= #" & e.Form.Controls("startdate").value & "# " & " And 加工日期 <= #" & e.Form.Controls("enddate").value & "# "
Dim g As New sqlgroupTableBuilder("统计表1", "加工单")
g.C
'
g.Groups.AddDef("加工日期", DateGroupEnum.Day, "日")
g.Groups.AddDef("款型及款号")
g.Totals.AddDef("重量")
g.Totals.AddDef("件数")
g.Totals.AddDef("单价")
g.Totals.AddDef("金额")
g.VerticalTotal = True
g.VerticalTotal = True
g.SubTotal = True
g.filter=filter1
g.Build()
g.SubTotal = True
g.filter=filter1
g.Build()