I'm wanting to set a background color in my report to turn red if one condition is like "DOM" and a second condition is either "USA" or "SEECERT". I have tried to get the syntax correct and haven't figured it out.
=iif(Fields!item_id.Value) Like "%DOM%" AND (Fields!coo.Value <> "USA" OR Fields!coo.Value <> "SEECERT"), 'Red', 'No Color'
Using Visual Studio 2012
The ItemID field is a varchar40
The coo field is a varchar255
I'm using Visual Studio 2012
I am entering this expression in the FILL section of Text Box Properties
I want to be able to change the color if the ITEMID contains the characters "DOM" in it and the coo is NOT either "USA" or "SEECERT"
"DOM" is an abbreviation for domestic. "DOM" can be anywhere within the field. Examples are:
The coo field stands for country of origin. Examples of this field are:
My goal is to be able to quickly show the report reader an Item ID that is supposed to be domestic having a coo something other than USA or SEECERT.