Results 1 to 2 of 2

Thread: Crystal Report Amortization Schedule

  1. #1

    Thread Starter
    Lively Member Carmell's Avatar
    Join Date
    Dec 2015
    Posts
    105

    Question 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.

  2. #2

    Thread Starter
    Lively Member Carmell's Avatar
    Join Date
    Dec 2015
    Posts
    105

    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
  •  



Click Here to Expand Forum to Full Width