0

Can't get flow filter to work

Jet Reports Historic Posts

May 28, 2009 16:41

None

Follow

Hi,
I have a JetReport to work with Native Navision 4.01 table 5200 Employee and just can't get Data Filter (which is a flow field) to work:
=NL("Rows","Employee",,"Date Filter","01/01/2009..12/31/2009","Company=","ABF")

Instead of showing employees that worked just in 2009 (Date Filter) reports shows everybody! What gives?

Thanks

Denis Petrov

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts May 29, 2009 15:11

  Hi Denis,
  
  I know we just talked about this on the phone but I wanted to make sure that others know the answer to your question. When you are using Flow Filters, you must have the Flow Field you are applying it to in your NL(). Since you are trying to get a list of employees that have been paid in 2009, your NL() should look like this:
  
  =NL("Rows","Employee",,"Date Filter","01/01/2009..12/31/2009","Company=","ABF","Amount","<>0")
  
  This will only list employees that have amounts in 2009. I hope this makes sense!
  
  Take care,
  
  Sarah

• 0
  
  Jet Reports Historic Posts May 29, 2009 16:12

  Sarah rocks, the problem is solved!
  
  Thank you Jet reports
  
  Good luck to all of us!