SQL Server Home
Dynamic Report Column Width
5/4/2010 8:50:51 AM
User(s) can reproduce this bug
This is in SSRS 2005. I have a report with 40 columns that are dynamically chosen by the user. The other columns which are not selected are set as hidden. However there are issues are while rendering as the report occupies the white space even for the hidden columns.
Is there any work around / patch in 2005 as we can not move to 2008 immediately?
SQL Server 2005 - Enterprise Edition
Windows Server 2003 (all x64 editions)
Operating System Language
Steps to Reproduce
Create a report with the width of all columns exceeding the standard page width.
Hide all the columns that are outside the page width.
Render the report in Winforms - Report Viewer control.
It does not displays the hidden columns, however retains the space of those hidden columns.
It should not retain the whitespace of the hidden columns and hence there are no blank pages while pringing the reports.
to post a comment.
Please enter a comment.
on 7/30/2010 at 11:43 AM
I tried the fix suggested in your blog entry but the body of my report didn't shrink even though the columns are hidden and the static column group property is set to hidden.
on 5/16/2010 at 4:02 PM
Answer provided. Closing.
on 5/11/2010 at 10:26 AM
Thank you for creating this feedback item.
The behavior you are seeing in Reporting Services 2005 (as well as Visual Studio 2005/2008 local mode Report Viewer) is expected - the report body cannot dynamically shrink below its definition width at runtime.
With tablix introduced in Reporting Services 2008 (and VS 2010 ReportViewer local mode), the desired effect can be accomplished now. Details and an example are available in this blog post:
SQL Server Reporting Services Team
to post a workaround.
Please enter a workaround.
© 2014 Microsoft