Reporting Services IF statement
Posted on 2010-11-23
I have the following If statement in Visual Studio reporting services:
=IIf(Fields!Company.Value = "company1", "Technical Hours", "Technical Sub Hours")
The issue I am having is that there are several values equal to "company1" in the database table, and several not equal to "company1" in the database, yet the Report is always outputting the title "Technical Sub Hours". The "Company" field is String data type. I have tried using Fields!Company.Value.toString().Equals("company1") but this does not work either.