Hidden rows in SSRS and Exporting to Excel issue

Question

I have a report that has 3 expandable columns. I have a condition in one of the rows that says the following for the hidden property:

=IIF(Parameters!GroupBy.Value = "Fleet", TRUE, FALSE)

Basically this is saying that if the parameter picked is Fleet then the hidden value is set to true otherwise its set to false. It looks perfect in the report preview but then when I export it to excel it shows these rows no matter what....

Whats the deal?

Answer 1

In my experience hidinng rows in excel doesn't work well. I suggest you instead use the expression to filter out the column from your dataset. It has the same effect but works better in excel.

In terms of filtering, you can either filter it in your sql, in the dataset, or in your table/list/chart.