locked
Two tables in one report.. RRS feed

  • Question

  • User2021533260 posted

    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?

    Friday, November 30, 2012 6:05 AM

Answers

  • User306743125 posted

    Yes, JOIN the reports in your SELECT query and use that as the dataset for your report

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, November 30, 2012 6:08 AM
  • User-929656654 posted

    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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, November 30, 2012 6:28 AM

All replies

  • User306743125 posted

    Yes, JOIN the reports in your SELECT query and use that as the dataset for your report

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, November 30, 2012 6:08 AM
  • User-929656654 posted

    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.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, November 30, 2012 6:28 AM