Dim t As Table = Tables("工程数据列表_tb承包方发票")
If t.IsSubtotal = False Then
Dim g As Subtotalgroup
t.SubtotalGroups.Clear()
t.GroupAboveData = True
t.TreeVisible = True
g = New Subtotalgroup
g.Aggregate = AggregateEnum.Sum
g.GroupOn = "发票日期"
g.TotalOn = "发票金额"
g.Caption = "{0}日 小计"
g.DateGroup = DateGroupEnum.none
t.SubtotalGroups.Add(g)
g = New Subtotalgroup
g.Aggregate = AggregateEnum.Sum
g.GroupOn = "*" \'注意总计分组用符号*表示.
g.TotalOn = "发票金额"
g.Caption = "总计"
t.SubtotalGroups.Add(g)
t.Subtotal() \'生成汇总模式
Else
t.ClearSubtotal
t.cols("不含税金额").GrandTotal = True
t.cols("税额").GrandTotal = True
t.cols("价税合计").GrandTotal = True
t.GrandTotal = True
End If