模拟关联,省略下面图的步骤
方法一
rt.Cells(5, 0).Text = "合计 " '打印合计
'rt.Cells(5, 4).Text = tbl.compute("Sum(数量)")
'rt.Cells(5, 5).Text = tbl.compute("Sum(金额)") & "元"
方法二
'rt.Cells(5, 4).Text = tbl.compute("Sum(销售明细.数量)")
'rt.Cells(5, 5).Text = tbl.compute("Sum(销售明细.金额)") & "元"
方法三
rt.Cells(5, 0).Text = "合计"
rt.Cells(5, 0).SpanCols = 3
rt.Cells(5, 3).Text = "[Aggregates!数量小计.Value]"
rt.Cells(5, 4).Text = "[Aggregates!金额小计.Value]"
专业报表无法合计,方法一,数量无值,金额显示一个错数据,方法二、三都没数据,如何解决?