CODEWITHSUNDEEP
reportingservices-2005reporting-servicesssrs-tablix
desi
desi

Reputation: 476

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?

Upvotes: 2

Views: 16667

Answers (3)

Sachin
Sachin

Reputation: 1

You can try setting Report property containerwhitespace="True".

Upvotes: 0

BulletProofPaper
BulletProofPaper

Reputation: 3

I do not consider this as the best solution but is more of a hack but this is what I did in my situation.

1)Place a white rectangle in the desired cell. Make sure that the rectangle is white and has no borders. 2)Place the textbox inside the rectangle. Set an expression to hide and show this textbox. 3)Repeat for each cell in that column.

Therefore, when the textbox is shown it will look as normal. When the the textbox is hidden, the white rectangle will work as a "placeholder" to occupy the cell.

Upvotes: 0

Frank Pearson
Frank Pearson

Reputation: 872

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.

Upvotes: 3

Related Questions