Have a column span all rows as one cell SSRS

1
votes

Desired output

I want to use ssrs to replicate this picture where the right column spans all the rows in the table. Right now I'm using a tablix with SSRS 2008.

2
reporting-servicesssrs-2008
Do you have any grouping of your data? Or just details? Also, will the IDC Comment will be static text? Or it will output some data from dataset? – grafgenerator
No groupings in my table right now just details. IDC Comment will be static – AmericanSuave

2 Answers

0
votes

You can create a tablix with only two columns and one row, delete the details group.

enter image description here

Then drag the tablix with your data and drop it inside the first cell of the previous created tablix.

enter image description here

The outer tablix contains in its first cell the inner tablix which contains the dynamic data.

Let me know if this helps.

0
votes

I dont know if you can put the Column on the right, but i could put it on the left.

Create a group on something that all the records have in common. In my example, All Customers are for the same Company.

enter image description here

This Group box label can be overwritten with another field, or rectangle to make the box Free Form for the Data that you need to spand across all records. Overwriting this field does not delete the group.

Here is the end result:

enter image description here