Hi I am trying to filter from my customers list all customers where the name starts with "Fon" (exclude group of customers).
I used the formula =NL("Rows","Customer","name","<>Fon*") but the list received includes these customers so it seems the filter is ingnored.
when I use instead =NL("Rows","Customer","No.","name","Fon*") I do get the filtered list of customers with name starting with "Fon"
why is it not working for me?
Gideon
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello Gideon,
The problem is that <>FON* is not a valid filter. Jet Reports has a knowledgebase article on this topic: http://kb.jetreports.com/article/AA-00582
I hope this helps!
Please sign in to leave a comment.