How to create If statement in Visual Studio reporting services
Posted on 2010-11-22
I know how to create a basic IF statement in Visual Studio reporting services. However, I would like to add another conidition to the statement. For example, I would like to check if a field equals a value AND equals another value. I have the following statement that I would like to add to:
=IIf(Fields!Company.Value = "value", "Technical Hours", "Technical Sub Hours")
I would like to say if the Company field equals "Value" AND the Acct field equals "Value2" THEN. Just like that but I do not know the syntax. Thanks!