CODEWITHSUNDEEP
reporting-servicesfontscolorsssrs-2008ssrs-tablix
user2331670
user2331670

Reputation: 335

ssrs show text different colour when field matches with another

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, "Green",  
or Fields!OrderBlockLetter.Value = Fields!DegreeBlockLetter.Value, "Orange",
or Fields!OrderBlockLetter.Value = Fields!AwardBlockLetter.Value, "Blue", "No Color")

But its not working. When saving this code it gives error.

I am using SSRS report builder.

Upvotes: 0

Views: 324

Answers (2)

Alan Schofield
Alan Schofield

Reputation: 21738

You can't use IIF with OR like that. IIF just returns a value if the expression is true and another if it's false. You can nest IIFs to get the desired results but using SWITCH is much simpler. Try this... (not tested but should be close enough)

=SWITCH
(
Fields!OrderBlockLetter.Value = Fields!InstitutionBlockLetter.Value, "Green",  
Fields!OrderBlockLetter.Value = Fields!DegreeBlockLetter.Value, "Orange",
Fields!OrderBlockLetter.Value = Fields!AwardBlockLetter.Value, "Blue",
True, "Black"
)

As switch returns on the first true expression, if all the others fail, the final expression is always True so the "Black" will be returned.

Upvotes: 3

Pants
Pants

Reputation: 679

EDIT: Actually, "No Color" is not a valid font. You either need to pick black (the default color), or white (to give the appreance of there not being text there)

Upvotes: 0

Related Questions