这里合成条件的例子：

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