How to remove blank Space in rdlc

1
votes

I am working with Rdlc report. I have these fields:

First name :       fn_data  

Address1  :         add1_Data

Address2  :        add2_data

City, state, zip : city_data

If any one of these fields is empty, it should not show the blank space. For example (expected output)

First name,
Address1,
City, state, zip
But, as show in the above image, I am getting this:

First name,  
Address1,  
........................<-(blankspace is showing here)  
City, state, zip

I tried changing Visiblity -> Expression -> ==IIF(IsNothing(Fields!add2_data.Value),False,True) How can I remove this Blanck Space??

1
vb.netrdlc

1 Answers

3
votes

In Visibility.Hidden property you have to specify if the object must be hide or not. So you can use:

=IIf(IsNothing(Fields!YourData.Value), True, False)

If you're using Table/Tablix you have to set Visibility property of your TABLEROW.