Hello All
I have a report which i want to filter data by two transaction types, lets say "apples" and "oranges". i have done this part.
i then need to put another line of code in to say, when transaction type = apple, then only filter for colour = "green apples"
this is the code i have come up with, but i cant get it to work:
case
when[Trans Type Code] = 'APPLE'
THEN [Colour]=('Green')
Any body know a solution?
thanks in advance
Shaun
Try this filter.
([Trans Type Code] = 'APPLE' and [Colour]=('Green')) or ([Trans Type Code] = 'orange'
and [Colour]=('Orange'))
Thankyou mate that worked!