I have one table of loans and another table of transactions that relate to those loans. I am trying to figure out how to produce a report that shows each loan in the loan table, and corresponding transaction totals.
Loan table: LOAN_NUM, BORROWER_NAME, FUND_DATE
Transaction Table: LOAN_NUM, TRANS_TYPE, AMOUNT
LOAN_NUM, BORROWER_NAME, FUND_DATE, SUM OF AMOUNT where trans_type = D, SUM OF AMOUNT where transtype = P
In access, I would create a couple queries and it would be done. I can't figure out an easy way to do in MS Reporting Services. Help!