Last post Nov 30, 2012 06:28 AM by Sirama
Nov 30, 2012 06:05 AM|cchidambaram|LINK
I want to display two tables in one single report as follows.
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?
Nov 30, 2012 06:08 AM|Basquiat|LINK
Yes, JOIN the reports in your SELECT query and use that as the dataset for your report
Nov 30, 2012 06:28 AM|Sirama|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.