在excel报表设计中如何实现按月小计,然后按月截止累计。数据统计中有这个功能:Dim t As Table = Tables("厦门海西金谷总账黄传雄")Dim g As SubtotalGroup
t.SubtotalGroups.Clear()
t.GroupAboveData = False
t.TreeVisible = False
t.SpillNode = False
g = New SubtotalGroup
g.Aggregate = AggregateEnum.Sum
g.GroupOn = "日期"
g.TotalOn = "项目垫付明细,福州付款明细,公司投入项目资金,项目部备用金付款,资金余额"
g.Caption = "{0}月 小计"
g.DateGroup = DateGroupEnum.Month
t.SubtotalGroups.Add(g)
g = New SubtotalGroup
g.Aggregate = AggregateEnum.Sum
g.GroupOn = "日期"
g.TotalOn = "项目垫付明细,福州付款明细,公司投入项目资金,项目部备用金付款,资金余额"
g.Caption = "{0}月 累计"
g.DateGroup = DateGroupEnum.Month
g.upto = True
t.SubtotalGroups.Add(g)
g = New SubtotalGroup
g.Aggregate = AggregateEnum.Sum
g.GroupOn = "*"
g.TotalOn = "项目垫付明细,福州付款明细,公司投入项目资金,项目部备用金付款,资金余额"
g.Caption = "总计"
t.SubtotalGroups.Add(g)
t.Subtotal()
由于不能插入截图,所以复制代码。