Hi all ,
I need a report which displays the subtracted amount from two column from 2 different tables whcih are not related.

For example:
table A and B.
Table A has amt_paid column and table B has total_amt column....amt_paid should be substracted from total amount and displayed in the reports. These 2 tables (A&B) has REv_Acct_code & date as common columns. Teh user enteres the date for that entered date it should subtract the (total_amount)-(amount_paid) and display along with rev_acct_code.

Rev_acct_code total_amt-amt_paid

10001 40 (which is total_amt(80)-amoutn_pd(40))

so on...