Skip to Content
0
Former Member
May 03, 2010 at 02:55 PM

Filtering on Variables

20 Views

I have 3 variables.

variable 1

if query 1.id <> query2.id then 9999 else 0000

variable 2

if query 1.customer<> query2.customer then 9999 else 0000

variable 3

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.