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?
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.
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.