0

Creating a Filter for multiple tables

Jet Reports Historic Posts

March 16, 2012 16:16

None

Follow

Hi,

I am looking to create a filter that involves multiple tables.
With the filter, I would like to capture all Purchase Receipts [Document No. from Purch. Rcpt. Line table], for which the Purchase Header has a certain user id as Assigned User. The Purchase Order could be in the Purchase Header Table, or already in the Purchase Archive Header table.

If anybody could help me, it is greatly appreciated.

Thank you,
Nicolai

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts March 26, 2012 15:50

  Hi Nicolai,
  
  It sounds like you could use the Link= functionality for this. Sounds like you want something like this:
  
  =NL("Rows","Purch. Rcpt. Line","Document No.","Link=","Purchase Header","No.","=Document No.","Assigned User ID","Your filter here")
  
  Does that help?
  
  Regards,
  Hughes