report viewer2010 - How to collapse a row in RDLC rather than just hide it?

Question

I have an RDLC report showing a table. A certain row in this table should not appear in some conditions apply. I was able to set the Hidden property to false using an expression if these conditions apply.

The problem is that, though hidden, the row is still taking place in the table, i.e. it is not collapsed.

How can I collapse it rather than simply hide it?

I am using RDLC with report viewer 2010 SP1

Answer 1

Despite the insistance that their solution works, the Hidden property still makes the row take up space. No big deal if it is the last row, but when it is between rows it can be a big deal. And Can Shrink is no help either. The solution to collapse the row is the right-click the row header and select Row Visibility..., then enter the expression that will evaluate to true or false.