0

Two base tables for Report Builder

Li Kong

December 05, 2017 19:47

None

Follow

Dear expert

May I know if it is possible to set two base tables in Data View for Report Builder? For example, sales invoice line and sales cr. memo line. 

My client would like me to create a base report with all the required sales information. Such as information from Sales Invoice Line, Sales Invoice Header, Customer Ledger Entries, Item Ledger Entries (Lot No.), and Sales Credit Memo Line and Sales Cr. Memo Header. 

Thank you.

 

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Janice Taylor December 06, 2017 19:52

  Hello,

  You cannot add a 2nd base table in this wizard, however, once you've created the report, you can amend the report in Design Mode and add secondary tables in at that time. You would have to adjust all your group levels. (e.g. NL("rows=3") will need to be changed to add more rows in the pattern. 

  Please note that with the release of Jet Professional 2018, we no longer include this wizard.