0

Merge field of 2 Table

Jet Reports Historic Posts

August 03, 2012 06:55

None

Follow

Hi all,
I want statistic number of Document on the Sales invoice header and Purchase invoice header each user and posting date and have some problems
Example:



above image:
01/01 and 01/03 in "sales invoice header" table and 01/02 and 01/04 in "Purch. invoice header" table.

values 12,17,45,21,16….. is total number of document in both "sales inv header" and "pur inv header" table each day

How to Merge "posting date" fiel on "sales inv header" and "pur inv header" when run and filter date on report and show date as NL(column,…..) on report

Thanks!

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts August 06, 2012 07:48 Official comment

  Hi,
  I have resolved this problem by use NP("Union",NL("Filter"…),NL("Filter"…)) for both date and user ID.

• 0
  
  Jet Reports Historic Posts August 06, 2012 01:58

  not solution ? :cry: