Crystal Report Amortization Schedule
I am actually trying to create a report that shows the Amortization Schedule using Crystal Report. I am curious if its possible to do this with this kind of format.
I have an input coming from user:
Loan Date: October 23, 2019
Loan Amount: 3,000.00
No. of Payment: 3
Amortization(Monthly): 1,000
So the details in the report will show like this:
1,000 on or before November 15, 2019
1,000 on or before December 15, 2019
1,000 on or before January 15, 2020
The start of the amortization will be next month every 15th day and will end after the 3rd month or depending to the No. of Payment specified by the user.
Thanks guys.
Re: Crystal Report Amortization Schedule
I create a formula to my crystalreport and added to my details how ever it only produce one line of details which is the end date of the loan
Code:
local numbervar i ;
local stringvar output;
for i := 1 to tonumber({LOAN;1.No_Payment}) do
(
output:= totext(DateAdd( "m",i, {LOAN;1.Loan_Date} ));
i=i+1;
);
output;