Dynamic sizing of SSRS Report

I have a report with 12 Tablixes on it. The user can pick and choose which one of these Tables and their associated data shows when the Report is generated. However, when chosing a subset of the 12 tables, the report shows blank space where I hide the non-selected tables. Is there any way to make the report resize/fit the size of the selected tables...truncating the white space where the开发者_运维技巧 invisible tables are?

Thanks

First off welcome to SO.

I personally have not been able to find a way to truncate that white space. The best solution I've found is to just design my reports around it.

Also, Sub-Reports, or a Tablix of Tablixes may come in handy for this solution.

So, yeah, those are the routes I would explore:

• Design report around white space
• Sub-Reports
• Tablix of Tablixes

put your tables on rectangles, and optionally hide the rectangles based on your requirements. In the report settings, set consume white space to true. That should do it for you.