主题：统计的数据复制到另外一个表

参考

http://www.foxtable.com/webhelp/scr/0680.htm

http://www.foxtable.com/webhelp/scr/1533.htm

Dim g As New GroupTableBuilder("统计表1", DataTables("表A"))
g.Groups.AddDef("日期", DateGroupEnum.Year, "年")
g.Groups.AddDef("日期", "月")
g.Totals.AddDef("销售额")
g.Totals.AddDef("销售成本")
g.Totals.AddDef("营业成本")
g.Totals.AddDef("净利润")
g.filter = "日期 is not null"
g.Build()

Dim Cols1() As String = {"年", "月", "销售额", "销售成本", "营业成本", "净利润"}
Dim Cols2() As String = {"年", "月", "销售额汇总", "销售成本汇总", "营业成本汇总", "净利润汇总"}
For Each dr1 As DataRow In DataTables("统计表1").Select("")
     Dim dr2 As DataRow = DataTables("表B").AddNew()
     For i As Integer = 0 To Cols1.Length -1
         dr2(Cols2(i)) = dr1(Cols1(i))
     Next
 Next

把所有的数据填充到一个表

http://www.foxtable.com/webhelp/scr/0680.htm

然后设置分组统计啊

 先填充在一起，才可以统计。

 生成临时表简单啊

 自己统计也可以，参考http://www.foxtable.com/webhelp/scr/0681.htm

http://www.foxtable.com/webhelp/scr/0688.htm