Link to home
Start Free TrialLog in
Avatar of Sue Taylor
Sue TaylorFlag for United States of America

asked on

ssrs expression help

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
SOLUTION
Avatar of Vaibhav Goel
Vaibhav Goel
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of ValentinoV
ValentinoV
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sue Taylor

ASKER

None of the solutions provided worked.  I would always get an error BC30201.

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:
     62C225BA2G/DOM/LW
     62C225BLIM/DOM
     50F300HCS8/DOM-NP

The coo field stands for country of origin.  Examples of this field are:
CHINA
TAIWAN
USA
SEECERT
JAPAN
INDIA

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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial