Search code examples
reportingservices-2005reporting-servicesssrs-tablix

SSRS report produces blank/white spaces when column are hidden in tablix

I have report developed in SSRS 2005. It is a simple and straight-forward report using a stored procedure to fetch the data and display. This report has 100 columns and there are no grouping or subreports etc.

But user has option to select/deselect the column names to show/hide on the report. When the user select to hide couple of columns report is giving me blank/white gaps when exported to pdf or any other formats.

Is there any solution to this?

Solution

  • You need to ensure that you are hiding the row or the column of the table and not simply the fields. Check HarlingtonTheWizard's post at the following link:

    http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=109566

    Once the rows/columns are hidden, the height/width will collapse.