Last post May 01, 2017 08:56 AM by Jean Sun
Apr 28, 2017 07:46 AM|nelsonrock101|LINK
I am getting the blank space in the report table section when I set row visibility to hidden based on the expression. I have also tried setting Tablix properties visibility to hidden based on expression, but still getting the same output. I want to wrap
table section after the element is hidden. Let me know please soon what needs to be done.
May 01, 2017 08:56 AM|Jean Sun|LINK
Here are detail steps to do it.
Right click on the Tablix Column (that little gray bar ABOVE your header box, this will give you a pop up menu that has a Column Visibility option. Use the Expression to indicate True or False for when you want it hidden.
You will notice that when you run the report and your condition is met that the columns to the right are now pulled over against the column to the left of your hidden column, thus eliminated the whitespace. In addition, even objects outside the Tablix that
are to the right of the Tablix will be pulled over as well.
For more information, link below is for your reference.
Will SSRS 2008 eliminate white space due to