Search code examples
reporting-servicesssrs-tablixssrs-2012

Hidden columns taking space on Report

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?

Solution

  • 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.