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.