-
Oct 23rd, 2019, 03:14 AM
#1
Thread Starter
Lively Member
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.
-
Nov 20th, 2019, 01:46 AM
#2
Thread Starter
Lively Member
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;
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|