Nested IF statement visual studio 2005
Posted on 2013-06-17
In the properties on a table column I need the column to print if I have a specific department.
If the department is "parts","service",or "special" I don't want it to print.
=IIF(Fields!DEPT_NAME.Value = "Parts",true,IIF (Fields!DEPT_NAME.Value = "service",true,(
IIF Fields!DEPT_NAME.Value = "Special",true,false))
If I get the syntax correct (no red line) then I get some kind of error when I execute.
The expression is in a table column under the visibility property.