Multiple Conditional Formatting in SSRS

I have a report in SQL Server Reporting Services 2005. I already have this condition set in the COLOR property. It is checking the field called "SalesRep".

=iif(Fields!SalesRep.Value = ".Bluebird - (New Client)", "Blue", "Black")

I now need to check another field called "Status", and if the status is RESCHEDULED I want to make the row Green. How would I make this expression work?
=iif(Fields!SalesRep.Value = ".Bluebird - (New Client)", "Blue", "Black")
=iif(Fields!Status.Value = "Rescheduled", "Green", "Black")
Who is Participating?
Auric1983Connect With a Mentor Commented:
Assuming because you're setting the row colour one would take precidence over the other?
This would check if its a new client, if yes the row will be blue, otherwise it will check for a rescheduled entry and be green... finally if its neither it will be black.

=iif(Fields!SalesRep.Value = ".Bluebird - (New Client)", "Blue", iif(Fields!Status.Value = "Rescheduled", "Green", "Black") )

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.