Hello!I'm having some difficulties with one of our reports.

The report has one table with about 40 columns. On most of these columns we have set a column visibility to false. Users can set the visibility to true with several parameters. The problem is we standard run the report with only about 3 columns visible and we get a lot of white space at the end of the table (the width of the other 37 hidden columns). Is it possible to dynamically shrink the width of the report? As you can (not) see in the picture below is the scrollbar on the bottom. The view report button is now far away on the right and not in the direct sight of the user. Any suggestions would be very helpfull!

For your understanding: 'Niet tonen' means 'Don't show'

'Tonen' means 'show'

• Edited by striker91 23 hours 39 minutes ago image

I am using SSRS in VS 2012. If the column visibility is set using parameters the report width gets automatically adjusted and fits into the page. 

Some suggestions:

1. If you have set any other components in report body which takes specific position & size, It will make the report to expand. please validate

All the best

Hi striker91,

According to your description, you have specified the column visibility based on the parameter, then you want to shrink body width automatically when some columns are hidden, right?

In Reporting Services 2008, its supported to dynamically hide table columns and shrink the width of the table (and the report body) at the same time automatically. To achieve the requirement, we could specify the Hidden property for the column in Advanced Mode to hide the actual table column. For more information, please refer to this article: Report Design: Shrinking Hidden Static Table Columns.

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu