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
rdlc file, select the control or table row that you want to show conditionally. On the View menu, choose Properties Window. In the Properties window, expand Visibility. Under Visibility, in the Hidden field, select <Expression…> from the drop-down list.
1 Answer. Show activity on this post. You want to create a parent group to your current rowset and set its group expression to =Int((RowNumber(Nothing)-1)/10. In the Group Properties you then check the Page Breaks option to "Between groups", (and toggle the visibility).
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.
Make sure that CanShrink is set to true.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With