Hidden columns taking space on Report

0
votes

I am working on a SSRS report and depending on column selection from user page, have to show/hide some of the columns. I am using expression on field value 

=IIf(Fields!CatalogueDescription.Value = "[-HIDE-]",false,true)

when report appears it shows wide space for columns hidden which is not right. Also when I tried to right click on SSRS tablix design time, the column visiblity... option is disabled, why, have no idea. How can I hide columns in such way without leaving blank/white space?

1
reporting-servicesssrs-tablixssrs-2012
do you have that on the field visibility expression or is that on the column visibility expression. – SFrejofsky
I tried on both column header and detail. I am using Tablix – Builder
Ok so I was doing some playing around and it looks like you may have your iif statement backward. The visibility property is a little backward depending on how you have the initial visibility of that column set. The visibility boolean is the toggle of visibility. So if the initial visibility is true and your visibility boolean is true then the toggle flips and visibility is set to false. It is not just simply visible "true" or "false. Check the initial visibility of your column and change your boolean accordingly. Also make sure that you are setting this expression in the Column visibility. – SFrejofsky

1 Answers

0
votes

I tried this and it worked.

On Tablix, right click on column and select visibility... and on expression use something like

=Fields!CatalogueDescription.Value = "[-HIDE-]"

Remember here it takes false to hide it. Or try your Boolean values and it will work for sure.