Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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

like image 416
Emad Gabriel Avatar asked Sep 20 '11 17:09

Emad Gabriel


People also ask

How do I show hidden rows in Rdlc report?

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.

How do I limit the number of rows displayed in an Rdlc report table?

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


2 Answers

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.

like image 97
Crowcoder Avatar answered Oct 05 '22 15:10

Crowcoder


Make sure that CanShrink is set to true.

like image 34
user1579726 Avatar answered Oct 05 '22 15:10

user1579726