0

Pulling data from multiple Tables

Jet Reports Historic Posts

October 14, 2009 22:56

None

Follow

Hello,

I hoping someone could give me an idea of how to go about pulling data from multiple tables. For instance if I wanted to get a list in rows of all the "no." from the Sales Invoice Header and Sales Header tables things like order date and Campaign No. are used as filters. The goal is to capture the current data as well as the historical data in one list. The only way i can think to do this is to pull the data from two tables. Any thoughts?

Thanks!

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts October 22, 2009 03:22

  Just put the 2 NL("Rows") Formulae underneath each other.
  
  in B4 put the first formula
  in b5 put the second formula
  i.e. =nl("Rows","Sales Header","No.","Order Date",$B$2,"Campaign No.","@@"&$B$3) =nl("Rows","Sales Invoice Header","No.","Order Date",$B$2,"Campaign No.","@@"&$B$3)
  In the attached ZIP is a basic report and another report with options ect.

  • List of Sales Invoices & Orders by Campaign.zip