March 4, 2015 at 8:46 pm
Hello Everyone,
I need to hide a row in SSRS that contains data based on another row that does not contain data. For example: If row on left side does not contain data, then the row on its right side should be hidden or be blank just like left row. I am using a matrix region.
Is there any expression that could do that? Please see screenshot attached and I thank you all in advance for the help.
March 5, 2015 at 8:51 am
robertdba (3/4/2015)
Hello Everyone,I need to hide a row in SSRS that contains data based on another row that does not contain data. For example: If row on left side does not contain data, then the row on its right side should be hidden or be blank just like left row. I am using a matrix region.
Is there any expression that could do that? Please see screenshot attached and I thank you all in advance for the help.
Do you want to hide the entire row if the value in the middle column is blank, or do you want to hide only the value in the right column?
To hide the entire row: (Directions using SSRS 2008 R2)
Right click on the row and choose Row Visibility...
Click Show or hide based on an expression
Click the fx button.
---create an expression that evaluates to true or false.
----It will hide the row when the expression evaluates to True.
Example expression:
=IsNothing(Fields!Engine_Component.Value)
To hide the value in a field:
Right click on the field and choose Expression...
Example Expression:
=IIF(IsNothing(Fields!Engine_Component.Value),"",Fields!Results.Value)
March 5, 2015 at 9:03 am
I was able to do it with the following expression below :
=IIf(Previous(Fields!Name.Value) = Fields!Name.Value, True, False)
The problem now is that there is a white space below which I need to remove, the white space are the empty cells/rows, any ideas on how to hide it?
The whole idea is that if there is an empty cell/row on the left side, then row that contains the value repair should be blank or hidden.
See screenshot and thanks in advance for the help.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply