这里合成条件的例子:
http://www.foxtable.com/help/topics/1058.htm
Dim k As Date = e.Form.Controls("startdate").Value
Dim j As Date = e.Form.Controls("EndDate").Value
Dim g As New GroupTableBuilder("景区日报表", DataTables("日统计表"))
g.Groups.AddDef("日期", DateGroupEnum.Day, "日")
g.Groups.AddDef("景区")
g.Groups.AddDef("大类")
g.Groups.AddDef("二类")
g.Totals.AddDef("总人次")
g.Totals.AddDef("有效人次")
g.Totals.AddDef("收入额")
g.Decimals = 0
g.Filter = "[日期] >= #" & k & "# And [日期] <= #" & j & "#"
g.Build()
MainTable = Tables("景区日报表")
With Tables("景区日报表")
.MergeMode = MergeModeEnum.Standard
.MergeCols.Clear()
.MergeCols.Add("日")
.MergeCols.Add("景区")
.MergeCols.Add("大类")
.MergeCols.Add("二类")
.MergeSort = "日,景区,大类,二类"
.AllowMerge = True
End With
最好看看下面的内容:
http://www.foxtable.com/help/topics/1284.htm