0

Can I link 3 tables?

Jet Reports Historic Posts

January 12, 2010 18:35

None

Follow

I am trying to sum a field and need to link three tables:

=NL("Sum","Posted Rental Line","Gross Amount","Link=","Posted Rental Doc. Dimension","Dimension Code","LEAD SOURCE","Document Type","Posted Invoice","Dimension Value Code",E16,"Line Type","0","Document No.","=Document No.","Link=","Posted Rental Header","Posting Date",$B$5,"No.","=Document No.")

1. is it possible to link three tables?
2. is my code correct?

Thanks.

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts January 14, 2010 18:12

  You can do this using Jet Reports 2009.
  
  You should look at the new features reference for Jet Reports 2009.
  
  http://community.jetreports.com/viewforum.php?f=36