ssrs show text different colour when field matches with another field

Question

I have a requirement to show different text color when one field matches with another three different fields.

I have written below expression,

=IIF(Fields!OrderBlockLetter.Value = Fields!InstitutionBlockLetter.Value or Fields!DegreeBlockLetter.Value or Fields!AwardBlockLetter.Value, "Green", "No Color")

But its not working.

I am using SSRS report builder.

Answer 1

That's not how the OR works.

You would need to use something like..

=IIF(Fields!OrderBlockLetter.Value = Fields!InstitutionBlockLetter.Value or Fields!OrderBlockLetter.Value = Fields!DegreeBlockLetter.Value or Fields!OrderBlockLetter.Value = Fields!AwardBlockLetter.Value, "Green", "No Color")