本文介绍了如何将合计添加到SSRS中的每个组的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我需要在SSRS中有一个行组内的每个分组的总数。当前，合计被添加到行组的末尾。
所以，如果我有以下数据：
TeamName BusinessSegment PaymentPeriod BusinessArea ProductType PolicyCount201501 Premium201501
--------------------------- ------------- ---------------- ---------------- ------------------ ---------------
Office Non-property Monthly Commercial Lines Sectional Title 0.00 0.00
Office1 Non-property Annual Commercial Lines C&I Generic (Web 1.00 24025.00
Office1 Non-property Annual Commercial Lines Property Protect 1.00 24025.00
Office1 Non-property Monthly Commercial Lines BizzInsure 1.00 24025.00
Office1 Non-property Monthly Commercial Lines Sectional Title 1.00 24025.00
Office2 Non-property Annual Commercial Lines Property Protect 1.00 24025.00
Office2 Non-property Annual Commercial Lines Sectional Title 1.00 24025.00
Office2 Non-property Annual Commercial Lines Sectional Title 1.00 24025.00
Office2 Non-property Monthly Commercial Lines M&F Commercial B 1.00 24025.00
Office2 Non-property Monthly Commercial Lines Sectional Title 1.00 24025.00
我希望输出如下：
Team Name Business Segment Payment Period Business Area Product Type Policy Count 201501 Premium 201501
Office Non-property Monthly Commercial Lines Sectional Title 0.00 0.00
Total 0.00 0.00
Monthly Total 0.00 0.00
Non-property Total 0.00 0.00
Office Total 0.00 0.00
Office1 Non-property Annual Commercial Lines Something1 1.00 1.00
Office1 Non-property Annual Commercial Lines Something2 1.00 1.00
Total 2.00 2.00
Annual Total 2.00 2.00
Office1 Non-property Monthly Commercial Lines Something1 0.00 1.00
Office1 Non-property Monthly Commercial Lines Something2 1.00 1.00
Total 1.00 2.00
Monthly Total 1.00 2.00
Non-property Total 3.00 4.00
Office1 Total 3.00 4.00
Office2 Non-property Annual Commercial Lines Something1 0.00 1.00
Office2 Non-property Annual Commercial Lines Something2 1.00 1.00
Total 1.00 2.00
Annual Total 1.00 2.00
Office2 Non-property Monthly Commercial Lines Something1 2.00 1.00
Office2 Non-property Monthly Commercial Lines Something2 1.00 1.00
Total 3.00 2.00
Monthly Total 3.00 2.00
Non-property Total 4.00 4.00
Office2 Total 4.00 4.00
Grand Total 7.00 8.00
请注意，PaymentPeriod按Monthly和Annually分组，Monthly后面有一个合计，Annually后面有一个合计。当前呈现以下内容(请注意每个PaymentPeriod分组末尾的单个Annual合计：
Team Name Business Segment Payment Period Business Area Product Type Policy Count 201501 Premium 201501
Office Non-property Monthly Commercial Lines Sectional Title 0.00 0.00
Total 0.00 0.00
Monthly Total 0.00 0.00
Non-property Total 0.00 0.00
Office Total 0.00 0.00
Office1 Non-property Annual Commercial Lines Something1 1.00 1.00
Office1 Non-property Annual Commercial Lines Something2 1.00 1.00
Total 2.00 2.00
Office1 Non-property Monthly Commercial Lines Something1 0.00 1.00
Office1 Non-property Monthly Commercial Lines Something2 1.00 1.00
Total 1.00 2.00
Annual Total 3.00 4.00
Non-property Total 3.00 4.00
Office1 Total 3.00 4.00
Office2 Non-property Annual Commercial Lines Something1 0.00 1.00
Office2 Non-property Annual Commercial Lines Something2 1.00 1.00
Total 1.00 2.00
Office2 Non-property Monthly Commercial Lines Something1 2.00 1.00
Office2 Non-property Monthly Commercial Lines Something2 1.00 1.00
Total 3.00 2.00
Annual Total 4.00 4.00
Non-property Total 4.00 4.00
Office2 Total 4.00 4.00
Grand Total 7.00 8.00
我该如何实现这一点？
推荐答案
将另一个子组添加到您的Payment Period组，并将总计添加到第二个组。从显示的第一组中删除该列(不删除第一组)。
输出：
这篇关于如何将合计添加到SSRS中的每个组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！