0

Dynamic Lookup For a Report Filter

Jet Reports Historic Posts

January 19, 2015 16:00

None

Follow

You can use the NL("Lookup") function on your options tab.

The formula you want for the vendor table is:

NL("Lookup","Vendor","No.")

if you want to give them a bit more information then:

NL("Lookup","Vendor",{"No.","Name"})

will give them the number and the name in the lookup, but return just the number.

More info here:

http://kb.jetreports.com/article/AA-00525/0/Using-NLLookup.html

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts January 19, 2015 16:00

  Hello All,
  
  I have a Jet Report (Essentials) which lists invoices at particular statuses within the system. E.g. unpaid, paid, awaiting approval.
  
  I have a filter in a cell of this report for "Vendor No. Filter". Can this be achieved as a lookup to NAV and for the user to select a vendor? At the moment it's free text.
  
  Thanks in advance.
  
  Andy

• 0
  
  Jet Reports Historic Posts January 20, 2015 12:04

  Thank you - that's worked a treat.