Wrapping a single column on a tablix
I am working a basic table type report but want to keep all my output to a single page. In most cases this is not an issue due to the nature of the data. These are 3-5 column reports and some columns have more data in them
than others. The basic report looks like:
Heading1
Heading2
Heading3
Heading4
A1
B1 C1
D1
A2
B2 C2
D2
B3 C3
D3
B4 C4
B5 C5
C6
The problem is I can only put 20 rows on the report before having to go to a second page if there is a column with more than 20 values. What I am looking for is a way to snake (like a news paper) just the one column that is
to long. So my report would look like the following with the values C21 – C24 in the third column wrapped back to the top.
Heading1
Heading2
Heading3
Heading4
A1
B1
C1
C21
D1
A2
B2
C2
C22
D2
B3
C3
C23
D3
B4
C4
C24
B5
C5
C6
.
.
.
C20
Does anyone have an idea on how to accomplish this? I have looked at the multi-column report feature in SSRS but that makes a second “column” of the entire table not just a single table column.
Thanks,
Barry
May 9th, 2011 11:23am
Hi
bwin13,
According to your description, you would like to wrapping a column on a tablix when the column have more than 20 values, right? Please correct me if my understanding is wrong.
I am afraid this cannot be achieved in reporting services at present. If you have any concern about this, please submit a feedback at
http://connect.microsoft.com/SQLServer/Feedback
and hope Microsoft improve this feature in the next service pack or product release.|
Thanks for your understanding
Thanks,
Eileen
Free Windows Admin Tool Kit Click here and download it now
May 12th, 2011 6:13am