Format Tablix with Row Grouping in SSRS

Question

I am trying to format a dataset in SSRS for readability and to meet design specifications. My dataset is returning expected values and I have created appropriate Row Groups, or at least I believe I have, for the report and when I preview the report - it looks correct, but just not the way I need it formatted.

The first two images are how I have the tablix formatted in SSRS and the row grouping I created.

And how the report looks when run:

And lastly, I have drawn a mockup of how I am hoping to format the tablix for this particular report - which includes having each particular row group in it's own row and the details ( questions and answers ) appear on on a separate row as well. The first section is the template while the rest is an example of data in the format I wish to have:

Anyone have any advice on how this could be accomplish?

Check out this link: https://direit.wordpress.com/2012/07/10/ssrs-create-child-group-in-same-column-below-parent/ — Snowlockk, Apr 13 '17 at 08:23
That link helped me achieve my desired result - but it's in a comment so I cannot mark as correct. — MISNole, Apr 17 '17 at 02:31

score 0 · Answer 1 · answered Apr 14 '17 at 13:17

0

Try formatting your report like this:

answered Apr 14 '17 at 13:17

SuperSimmer 44

964
2
7
12

I tried removing the Details row and it did not result in the desired format. – MISNole Apr 17 '17 at 01:48

Format Tablix with Row Grouping in SSRS

1 Answers1