Skip to Content
0
Former Member
Sep 08, 2007 at 03:43 PM

how to design a report with datasource that is multi tables ?

27 Views

Post Author: nesaver

CA Forum: General

I have 2 tables :

Sale

SaleID

Date

Money

2. Buy

BuyID

Date

Money

I want to design a report which shows : sum of sale money = A, sum of buy money = B, A-B; in a month. But, if Sale table has 10 rows and Buy table has 3 rows (in specific month), the report that I designed has 30 rows details -> sum of sale money, and sum of buy money are wrong.

Can you help me ?

Thank for support 😊