所有数据组合统计:
Dim g As New GroupTableBuilder("统计表1", DataTables("产量"))
g.Groups.AddDef("操作台")
g.Totals.AddDef("实际产量")
g.Build()
MainTable = Tables("统计表1")
筛选本有数据的例子:
Dim y As Integer = Date.Today.Year
Dim m As Integer = Date.Today.Month
Dim dt1 As New Date(y, m, 1)
Dim dt2 As New Date(y, m, Date.DaysInMonth(y, m)) '获取本月的最后一天
Dim Filter As String
Filter = "日期 >= #" & dt1 & "# And 日期 <= #" & dt2 & "#"
DataTables("订单").LoadFilter = Filter
DataTables("订单").Load()
如果数据没有进行筛选,这样应该如何在组合统计中加入筛选条件