0

I have been ordered to do a report with a pretty sophisticated table layout. Okay, it's not that sophisticated, but we all know how SSRS is with those things. I am pretty certain that layout cannot be achieved, but I want some feedback before I start simplifying it.

table layout

This is the table layout. I've replaced everything with 'header' and 'data' accordingly. What gives me a tiny bit of hope is that the dataset will always return one row, so I may ignore the header and detail regions assigned by SSRS. I only need to somehow achieve that layout and I'm good.

I have tried using matrix, it lets me merge cells vertically but then it only lets me merge them horizontally if it is the upppermost row. So guys, is there any chance to insert the photo the way it is done in the image (merging 10 rows vertically and 2 rows horizontally altogether in the middle of the table)?

Kind regards, Mash

  • Why not use sub reports? Have a sub report for each header/data group. Build each component separately, then combine into one report. – Anthony Genovese Jun 26 '17 at 17:35
  • I can't see how sub reports would achieve the desired layout, unless I'm missing something. – Mashchax Jun 27 '17 at 12:02
1

If you're using a single dataset which returns a single row, this should be pretty easy to achieve.

Not with subreports, but rather "sub tables". Create separate tables for certain areas, then drag and drop them in to appropriately sized cells within the main table.

Create a table, then another with the content you want to place in a certain position. Size the container cell accordingly (you can merge horizontal cells in the master to achieve this if necessary) or else things start to go a bit weird:

Size the cell in the master to to table you want to places there

Then drag & drop the sub-table in to place:

Drag the sub-table in to the cell

The tables have to have a dataset in common, which is fine in this context if I understand your description. And I think there are limits as to which area of a table you can place sub-tables, but other than that it can be a pretty powerful tool.

And I think your approach of ignoring headers and footers is right for this example. Just use detail rows for everything. Create as many as you need.

Hopefully I've given you enough to experiment with. I can expand on this at a later date if you need it.

  • Thanks a lot for your feedback, I will try experimenting with that and let you know how it worked out. – Mashchax Jun 27 '17 at 12:50
  • I played a bit with a few different ideas but ended up using your approach eventually. I'd say it's the best approach and the tool definetely gives some nice opportunities, however SSRS is a freaking poltergeist and the browser renderer shifts elements to sides or doubles the borders even if everything is perfectly lined up and shows up correctly in the preview in Visual Studio... This is very frustrating and I will probably have to make the report borderless and then correct the shifts with padding. But well, that's Microsoft's fault. – Mashchax Jun 28 '17 at 15:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.