I created (or trying to do so) a report that gives me a list of all my customers.
Now… I'm trying to filter some of the results out like blank fields.
I don't want to see any blank fields in the E-mail, City, State, Zip Code fields
I've tried using >Null and <>@@ which looked like this in the filters
City
<>@@
or
City
>Null
I keep getting different results each time i change something. could someone give me a quick lesson in these filters?
using Jet Reports 4.0.7
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Immortal,
My first reaction was… Version 4? :o That's like you're still driving a T Ford today if you compare it with the current version 7 :)
Do you have a copy of the documentation? Here's a link http://support.jetreports.com/index.php?_m=downloads&_a=viewdownload&downloaditemid=5&nav=0,3. Look at page 35 for all kind of filter options.
<>'' (unequal single quote single quote) means unequal to blank. -
Jet Reports Historic Posts What hans said… the key is to just use NAV filters.
'' (two single quotes) in NAV will return you all blank values, so <>'' is what you need, unless we missunderstood you.
Because you are using NAV filters, you can use the following operators too:
.. (from.., ..to or, from..to)
| (OR)
& (AND)
<> (NOT)
< (smaller than)
> (larger than)
? (single char joker)
* (multi char joker)
PS: maybe it's not a bad idea to consider an upgrade, like Hans stated.
Please sign in to leave a comment.