Hi all,
in a report I have to filter datasets on a codefield using 2 filters like this:
<>CANCELED| <>MISTAKE
How can I tell jet to set a filter like that? Everything I tried until now didn't work…
Thanks for all suggestions
Date
Votes
2 comments
-
Jet Reports Historic Posts It depends what you're after in the results. the | gets tricky when you start using <>
When you say CANCELLED|MISTAKE, logically speaking you are saying 'OR'. i.e. It can be Cancelled or a Mistake.
When you say CANCELLED&MISTAKE, logically speaking you are saying 'AND'. i.e. It has to be be Cancelled and a Mistake. Typlically this would never be used as it would always return nothing.
When you say <>CANCELLED|<>MISTAKE, logically speaking you are saying 'OR'. i.e. It can be 'Not Cancelled' or a 'Not Mistake'. This will return everything. i.e. 'CANCELLED' will validate as try against <>MISTAKE and vice versa.
I believe what you want is <>CANCELLED&<>MISTAKE. This will says 'Not Cancelled' and 'Not a mistake'.
Give that a try, see if you get the results you're after. -
Jet Reports Historic Posts You're right - it works!
Thanks a lot!
Please sign in to leave a comment.