question

siugoalie78 avatar image
siugoalie78 asked

SSRS Column Width growing, Text not wrapping

I am creating a report with SSRS, SQL Server 2008-R2. The report has a few matrices, each with the same number of columns, pulling data from different data sets, to give the appearance of a single table. When I render the report in VS, the columns look fine. Columns with long strings of text wrap the text, and the columns stay in alignment. This is the behavior I want from the report. However, when I run the report from a browser (IE or Firefox), the text does not wrap, and the column width expands to fit the text on a single line. This leaves the report with columns of different size, when they should be the same. Is there a way to force the text to wrap and prevent the column width from expanding? I tried the "Can Grow" property, but it looks like that applies only to height, not width.
ssrs-2008-r2
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Flathead_SQL avatar image Flathead_SQL commented ·
Not sure if you found a solution, but I had the same issue and this older post solution (style sheets) worked for me. http://ask.sqlservercentral.com/questions/35758/how-to-make-a-tablix-cell-wrap.html
1 Like 1 ·
siugoalie78 avatar image siugoalie78 commented ·
Thanks - I'll take a look at that. So far, my solution is to have the user to dump the report to Excel, where it lines up and wraps just fine.
0 Likes 0 ·
siugoalie78 avatar image siugoalie78 commented ·
Sorry for the slow reply. Looks like that did what i needed! Thanks!
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.