I have 3 variables.
if query 1.id <> query2.id then 9999 else 0000
if query 1.customer<> query2.customer then 9999 else 0000
if query 1.name<>query2.name then 9999 else 0000
I want to filter report
variable 1=9999 or variable2=9999 or variable3=9999
For some reason I can only seem to filter by one of them and only at a global filter.