Hi
I have some reports, that has been running for several years. Then our very old navision 3.70 had a run-time update to 6.0. Suddenly some of the reports - using NL("Filter";) didn't work. Then we updated to Jet-version 10.1, but the reports still doesn't work.
It is primarily when I am starting in G/L Entry looking/filtering into the Customer-table and filtering on Customer Posting Group. It fails and gives me a comment about "Unvalid filter: ' "
Have any ideas about this?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
It sounds like you have blank values for the field you're returning with the NL(Filter). So if you have a function something like this:=NL("Filter";"Customer";"Customer Posting Group";…)
Probably the issue is that one or more of the records in the Customer table have a blank value for Customer Posting Group. Of course, as you know you can't filter by a blank value in Jet, so when the G/L Entry table is being filtered by the values returned from the Customer table, when it gets to the blank value it returns an error. I think you should be able to deal with this by filtering out records that have a blank Customer Posting Group like this:=NL("Filter";"Customer";"Customer Posting Group";"Customer Posting Group";"<>''";…)
Notice I'm using 2 ' marks to filter out blanks not a ". Does this help?
Regards,
Hughes
Please sign in to leave a comment.