Hi all--
I have to create(modify) a report for Loan statements that are mailed quarterly. The report consists of a main report and a sub report that lists all the payments received in the statement period. Each report (per loan) is printed on a preprinted form.
Recently, some accounts have begun paying more often then due with some accounts having as many a 24 payments in the quarter. The template only allows for 9 payments in the sub form area.
How can I make the report print a second (or third or additional) page for the record based in the number of records in the sub report. I would prefer to print the reports on the same preprinted form, and xxx out the unnecessary fields on the subsequent pages.
The main form query contains the account data (name, address, balance, next due, last paid etc) the sub report query contains the ‘history data’ (data for each payment, date amount, due date, principal, interest… etc) the main report and sub report are linked by a similar field (accountID)
Thanks in advance.
I have to create(modify) a report for Loan statements that are mailed quarterly. The report consists of a main report and a sub report that lists all the payments received in the statement period. Each report (per loan) is printed on a preprinted form.
Recently, some accounts have begun paying more often then due with some accounts having as many a 24 payments in the quarter. The template only allows for 9 payments in the sub form area.
How can I make the report print a second (or third or additional) page for the record based in the number of records in the sub report. I would prefer to print the reports on the same preprinted form, and xxx out the unnecessary fields on the subsequent pages.
The main form query contains the account data (name, address, balance, next due, last paid etc) the sub report query contains the ‘history data’ (data for each payment, date amount, due date, principal, interest… etc) the main report and sub report are linked by a similar field (accountID)
Thanks in advance.
