Conditional Style like that of a conditional filter

[jmills]

I have created a report which shows all employees accross all of the 4 Organization Levels within a company (Department, Section, Cost Centre, Crew).  The intent of the report is to identify employees who have been assigned to incorrect crews/cost centres etc. based on specific rules.  The rules have been setup in a Date Item containing the following CASE statement:
Case (when Department = 'Admin' AND Section in ('x', 'y','z') AND Cost Centre = 'H100000' and Crew = 1000000) then (0) Else (1) END

Using this data item, I can then filter the report on data item =1 to show any mismatched org levels. 

What i'd like to do is create a conditional style that highlights which part of my Case statement is incorrect.  Is this possible? and if so, what is the best method?

[saumil287]

Hi,

You can set up a style variable with boolean variable, so based on a condition if your condition is not satisfied ie results of boolean set as No.
There you can set the color where condition is not satisfied.

[Lynn]

You could also used an advanced conditional style rather than a style variable. You need to figure out a comprehensive set of all possibilities to address situations where more than one element is the reason for the issue.