How to collapse a row in RDLC rather than just hid

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

Make sure that CanShrink is set to true.

Answer 2

Check this solution

set Hidden property to True or False

= (Fields!UserName.Value.ToString() = "")

Also check expression examples

Hope this answer help you.

Answer 3

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.