0

Problems with Filtering using NL function

Jet Reports Historic Posts

September 03, 2009 21:03

None

Follow

Hi,

In my item ledger entries I have a filed indicating which bank was used for payment. the field can take on of 4 values,
FOR A
FOR B
CRED A
CRED B
And Blanks
I would like to create two lists of all purchases with FOR as bank or blanks and a second list including all purchases with CRED as bank.

I thought of the following:
one list: NL("rows","item ledger entry","Lot","Bank","<>CRED*")
the second list: NL("rows","item ledger entry","Lot","Bank","CRED*")
The seoncd list shows indeed all the entries with CRED banks but the firs list returns all the entries from all banks so the filter seems not to work for the first list.

do you have an idea how to design the filter correctly.

Gideon

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts September 04, 2009 07:41

  Using the <>, >, >=, <, <= in combination with * or ? does not work in either JetReports or Navision.
  
  Try FOR*|' ' as a first filter and CRED* as the second one.

• 0
  
  Jet Reports Historic Posts September 06, 2009 14:34

  Thank you. That worked indeed.
  
  Gideon