<div>
Use a query like this as the source of your report:<br />

<pre><code id="code-20-35698564-1">Select loan.LOAN_NUM, loan.BORROWER_NAME, loan.FUND_DATE, sum(transaction.AMOUNT) as Total
from loan inner join transaction on loan.LOAN_NUM = transaction.LOAN_NUM
where  transaction.trans_type = 'D'
group by loan.LOAN_NUM, loan.BORROWER_NAME, loan.FUND_DATE</code></pre>
Didn't test it so it might need some tweaking.
</div>


Use a query like this as the source of your report:


Select loan.LOAN_NUM, loan.BORROWER_NAME, loan.FUND_DATE, sum(transaction.AMOUNT) as Total
from loan inner join transaction on loan.LOAN_NUM = transaction.LOAN_NUM
where  transaction.trans_type = 'D'
group by loan.LOAN_NUM, loan.BORROWER_NAME, loan.FUND_DATE

Didn't test it so it might need some tweaking.

<div>
what about the sum of 'P' transactions though? &nbsp;How do I get both 'D' and 'P' in the same query?
</div>


what about the sum of 'P' transactions though?  How do I get both 'D' and 'P' in the same query?

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


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

Desired output:

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!

How to join flat and deep tables in MS SQL Reporting Services

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.