Microsoft Report Builder - Full width summary row in a child group

Question

I have an SSRS report containing a parent and child row group. At present, this displays as:

I want to add a summary row to the "Child Group" but have it span the entire row. For example:

I also want the data for the "Parent Group" to repeat on every row whereas the data for the "Child Group" only appears once per value.

I'm migrating the report from another source, hence the odd requirements.

Thanks.

Answer 1

I think I've found a solution:

1. Delete column associated with "Child Group" but retain the group
2. Select "Parent Group" column, insert column within group - Right
3. Set the value of this volume to "Child Group"
4. Delete column associated with "Parent Group" but retain the group
5. Select "Child Group" column, insert column within group - Left
6. Set the value of this volume to "Parent Group"

This resulted in something similar to:

Then I:

1. Selected the "Data 1" cell, selected add total after
2. Merged all the cells in the row and added my data
3. For the "Child Group" I selected the "Hide Duplicates" ("Child 1") option
4. Then set the top and bottom border of the "Child Group" to none

which gave me:

Answer 2

Hi @Peter Bishop,

Glad to hear that your issue has been resolved, if you have any more questions, you may also post it on Q&A.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.