0
votes

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.

Tablix

Row Grouping

And how the report looks when run:

Report Preview

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:

Template

Anyone have any advice on how this could be accomplish?

1
I'll take a look at this link and see if it can help me. - MISNole
That link helped me achieve my desired result - but it's in a comment so I cannot mark as correct. - MISNole

1 Answers

0
votes

Try formatting your report like this: enter image description here