0

TABLE BUILDER WITH MUTIL TABLE ?

Jet Reports Historic Posts

June 18, 2012 03:09

None

Follow

Hi all,
I'm using Report and I have a sample about Table Builder Function
I want to use two table Item and Sales invoice line for report. Per 1 record on Item table link mutil record on sales invoice line table.But when i view report 1 record on item table - 1 record on sales invoice line only.

Builder


Result


How do Report view item - sales invoice line : 1 - n

Thanks!

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts June 18, 2012 05:56

  Hi Anhnd,
  
  You start with Item and then link to Sales Invoice Line. Well, if you turn that around it will work. So Sales Invoice Line as your 1st table in the Table builder, and then link to Item. The idea is that Jet reads the first table, and then by linking to the second table allows you to add fields from that table.
  
  Does that make sense? Does it work?