Search code examples
reporting-servicesdynamic-resizing

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

Solution

  • 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