Hello all
I am trying to get list of item numbers with a filter to exclude numbers with aa (or AA) in them:
=NL("rows";"item";"no.";"no.";"<>*@aa*")
But it is returning all item nos.
Instead I have now made 2 filters and difference:
=NL("rows";NP("difference";NL("filter";"Item";"no.");NL("filter";"Item";"no.";"No.";"*@aa*")))
Is there any way I can create a filter without having to use difference ?
Thanks and best regards
mdp12
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Sorry, this is due to a bug in Navision that doesn't allow for NOT and a wildcard (ie <>XX*).
However, I did do some additional testing and this does seem to work with the SQL Server version of Navision. I tested on NAV 5.01 and 6.0 (NAV2009) SQL versions using the customer table with the CRONUS USA database.
=NL("Rows","Customer","Name","Name","<>*@bb*")
and all the customers with bb were removed from the list. If I did this with a Navision Server, then nothing would be excluded. The only workaround is to use the NP("Difference"). -
Jet Reports Historic Posts Thank you for the answer.
I am on a Navision server, so at least now I know why it did not work.
Thanks again for your support.
mdp12
Please sign in to leave a comment.