reporting services 2008 table column width resizing
We converted a report from RS2005 to RS2008 and discovered a problem with the 2008 version. The table contains several columns with CanGrow turned on so text that is too long for the column will wrap and the row height will increase to accommodate the text.
We have a situation where the data coming back from the database is too wide for the column and should wrap, but instead of wrapping the text, the column width is being increased.
We narrowed down the circumstances where this will occur:
- the text that is too wide for the column does not have any spaces in it. Normally wrapping would occur where there is a space if possible, otherwise wrapping will occur in the middle of a word.
- the column headers have text labels that wrap
The only way we were able to resolve the problem was to remove the header row and instead add textboxes above the table to simulate the header row.- Moved byMike Walsh MVPMVP, ModeratorWednesday, November 04, 2009 3:00 PMwrong forum and use the question type. This is a techical Q+A forum so I presume you are asking for a better way to do this. (From:SharePoint - Excel Services)
- Changed TypeMike Walsh MVPMVP, ModeratorWednesday, November 04, 2009 2:59 PMquestion
All Replies
- Mike, can we move this back to SQL Reporting Services Forum- as the issue is not with Sharepoint.
Thanks.
