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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics