1

I'm looking to merge vertical rows for only a single column of my report, so that when that column has lots of data, it doesn't force the left rows to expand.

The answer appears to be using a matrix (e.g. SSRS tablix Merging cells vertically problem), but I'm not clear how it would work in this case.

For example, in the screen-shot below, I'd like to spread the confirmation footer text through the following 4 rows, so that the first row (Sales Contact, Angela Thomson, Confirmation Footer, The credit card used...) is the same width as the others and that the Sales Contact info on the left is not pushed down (i.e. the Title row should be just below Sales Contact, and not have all that space in between.

Any thoughts on this?

enter image description here

VBStarr
  • 586
  • 6
  • 17
  • Is there more than one record of data for the report and if there is more than one record how does the report repeat? Is there any data to the right of the confirmation footer? – cabbagetreecustard Jun 10 '18 at 08:49
  • There can be multiple records yes, but it is a single-record per page format, with the multiple rows showing data from the single record. There are no columns to the right of the confirmation footer. – VBStarr Jun 10 '18 at 16:32

1 Answers1

2

You could use a series of nested tablixes. Create each tablix in your report then drag and drop into the main tablix until you get the effect you're after. (nested data regions reference).

Here's the design of 3 nested tablixes

design of 3 nested tablix

Here's the preview of the report

report preview

Community
  • 1
  • 1
aduguid
  • 3,099
  • 6
  • 18
  • 37
  • If my answer sorted you out, can you please click on the check mark beside the answer to toggle it from greyed out to filled in. :) – aduguid Aug 16 '18 at 12:15