Hide rectangle in report Visual Studio

Bor1980

Hi all,

Within a report I added a rectangle and within this rectangle a table with rows from SalesLine table.
I want to hide the rectangle when the table does not have 20000 as No_



For this rectangle I have this part of code in the Rectangle properties - Visibility: =IIF(Fields!No2_SalesLine.Value<>20000,True,False)

Unfortunately the rectangle with table is still shown unless the orderline has not 20000.

What am I doing wrong?

Bor1980

Maybe my question was not clear enough?

I only want to show a textbox when the SalesLine table contains the article number 20000 or 60000.
I have now set this visibility but this does not work?
=IIF(Fields!No2_SalesLine.Value=20000 or Fields!No2_SalesLine.Value=60000,False,True)

manju

Hi,

Instead of setting visibility in rectangle, please try setting row visibility in the detail part of the table.

Cheers,

RockWithNAV

Absolutely with Row visibility you wont have white spaces.