Hello,

I am trying to find a good resource or sample code for generating monthly loan statements in SSRS based off of information in T-SQL tables (such a loan amount, interest rate, taxes, insurance, due date, etc.). I have a query to summarize an entire amortization schedule if the borrower makes all payments on time, but I have no dynamic way of showing a daily balance based off of compounding interest taking into account how much the borrower has paid or has not paid (which may be greater than or less than their monthly payment amount). I also want the functionality to add a Late Fee to the principal balance if the payment received date is after 10 days of their due date. All of these loans have the same terms and I don't want to spend a lot of money buying another piece of software to be able to pull of the transactions being stored in SQL. Any suggestions for a good, cost-effective way to enable SSRS the run these calculations and generate monthly statements with that information?

Thanks in advance