将小计添加到 SSRS 报表 Tablix

问题描述

说我有这个记录..

lastname firstname mi checkno 金额 totalamount姓氏1 名字1 mi1 k1234 5000姓2 名2 mi2 k1234 5000姓氏3 名字3 mi3 k1234 5000姓氏4 名字4 mi4 k90788 5000姓氏5 名字5 mi5 k90788 5000姓氏6 名字6 ​​mi6 k90789 500030000

我可以让这个记录在 ssrs 中看起来像下面这样吗?

lastname firstname mi checkno 金额 totalamount姓氏1 名字1 mi1 k1234 5000姓氏2 名字2 mi2 k1234 5000姓氏3 名字3 mi3 k1234 500015000姓氏4 名字4 mi4 k90788 5000姓氏5 名字5 mi5 k90788 500010000姓氏6 名字6 ​​mi6 k90789 50005000

希望有人能帮我解决这个问题.谢谢

解决方案

首先，向 Tablix 添加一个行组:

指定分组应该在checkno"列上，并在组中添加一个页脚(以保存小计):

最后，在组页脚中添加求和计算.(可选)删除包含组标题名称的最左侧列:

你瞧:

say i have this record..

lastname  firstname  mi  checkno  amount  totalamount

lastname1 firstname1 mi1 k1234    5000
lastname2 firstname2 mi2 k1234    5000
lastname3 firstname3 mi3 k1234    5000
lastname4 firstname4 mi4 k90788   5000
lastname5 firstname5 mi5 k90788   5000
lastname6 firstname6 mi6 k90789   5000
                                          30000

can i make this record to look like the following in ssrs?

lastname  firstname  mi  checkno  amount  totalamount

lastname1 firstname1 mi1 k1234    5000
lastname2 firstname2 mi2 k1234    5000
lastname3 firstname3 mi3 k1234    5000
                                          15000
lastname4 firstname4 mi4 k90788   5000
lastname5 firstname5 mi5 k90788   5000
                                          10000
lastname6 firstname6 mi6 k90789   5000
                                           5000

hope anyone can help me fix this. thank you

解决方案

First, add a row group to your tablix:

Specify that grouping should by on column "checkno", and also add a footer to the group (to hold the subtotals):

Finally, add the sum calculation in the group footer. Optionally remove the left-most column containing the group header name:

Èt voila:

这篇关于将小计添加到 SSRS 报表 Tablix的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！