When you are joining, make sure you pick the column that relates the two table. It looks the first column in your two table is related. But the relationship is not direct as it goes through the master table that should be linked with both Purchase and sales.
So you should bring the product table (I guest that is your master table) to relate both purchase and sales.
cchidambaram
Member
136 Points
115 Posts
Two tables in one report..
Nov 30, 2012 10:05 AM|LINK
Hi,
I want to display two tables in one single report as follows.
Purchase sales
1 abc def 1 afds fdsa
2 fdas fedaf 2 vdsa fvdasfda
3 fcd fde 3 vds gdag
Is it possible to create like this?
Basquiat
Contributor
2378 Points
625 Posts
Re: Two tables in one report..
Nov 30, 2012 10:08 AM|LINK
Yes, JOIN the reports in your SELECT query and use that as the dataset for your report
Sirama
Member
283 Points
67 Posts
Re: Two tables in one report..
Nov 30, 2012 10:28 AM|LINK
When you are joining, make sure you pick the column that relates the two table. It looks the first column in your two table is related. But the relationship is not direct as it goes through the master table that should be linked with both Purchase and sales. So you should bring the product table (I guest that is your master table) to relate both purchase and sales.