显示父组中的子组合计

Question

我有一个有4个组的报告。按层次列出的组包括：

member name
plan
status
open/closed

我需要一起显示成员级别的所有详细信息，在详细信息之后，我需要显示打开/关闭、状态、计划、成员的总数。

我将试着给出一些报告应该是什么样子的大纲。

Member1
name  plan   joined_date status open/closed term_date amount_paid amount_due
john  plan1  04/02/15  Approved open  10/16/2018  20045.00  1045.00
kate  plan1  04/02/15  paid     closed 10/16/2018 1080.00   1080.00
charles plan1 04/02/15 paid open 10/16/2018 11956.00 956.00
smith plan2 04/02/15 denied closed 10/16/2018 2500.00 0.00
thomas plan2 04/02/15 approved open 10/16/2018 34590.00 1590.00
Plan1  number of details:3
approved/open  number of details:1   20045.00   1045.00
paid/open   number of details:1   11956.00   956.00
paid/closed   number of details:1   1080.00   1080.00
denied/closed   number of details:0  0.00  0.00
Plan2  number of details:2
approved/open  number of details:1   34590.00  1590.00
paid/open   number of details:0
paid/closed   number of details:0
denied/closed   number of details:1   2500.00   0.00
total for member1 number of details:5  110,000.00  89,987.60

总数中定义的状态/打开/关闭只有4种变化。但可能有多个计划和多个成员。

我不能把状态和计划的总数放在细节中间。

Answer 1

我想明白了。我删除了子组计划状态和打开/关闭的详细信息，并添加了具有组计划、状态和打开或关闭的新表。为新表的详细信息行添加了合计，并隐藏了详细信息行。