0

I'm trying to hide/suppress data using an expression for Row Visibility in SSRS. I currently have an expression:

=IIF(CInt(Fields!EM_ET.Value)=1 Or CInt(Fields!EM_ET.Value)= 2,True,False)

That hides certain data I do not want to appear, but I would like to add an additional field to hide as well.

I tried adding an additional values with:

=IIF(CInt(Fields!EM_ET.Value)=1 Or CInt(Fields!EM_ET.Value)= 2,True,False
Or CInt(Fields!MobileType.Value)<>1,True,False)

Used "Or" and "And" to make it work neither does. Any suggestions on what is wrong?

Pedram
  • 6,256
  • 10
  • 65
  • 87
MISNole
  • 992
  • 1
  • 22
  • 48

1 Answers1

0

Try this:

=IIF(CInt(Fields!EM_ET.Value)=1 Or CInt(Fields!EM_ET.Value)= 2,True,IIF(CInt(Fields!MobileType.Value)<>1,True,False))

or

=IIF(CInt(Fields!EM_ET.Value)=1 Or CInt(Fields!EM_ET.Value)= 2 Or CInt(Fields!MobileType.Value)<>1,True,False)
Josh Jay
  • 1,240
  • 2
  • 14
  • 26