If you are unsuccessful in getting a report variable to compare against another variable – it’s because the syntax of the Reporter WHERE clause does not support it. Can’t do it.
See this entry from our Reporter FAQ: Why do I get a Syntax Error (DMB0007) when I try to Sum() Where ( > 2000)?
The syntax has to be WHERE <variable/object> = constant.
The FAQ cited above suggests a work-around for one situation, perhaps you can figure out another for your case.
Anita Craig 
(BOB member since 2002-06-17)