How to print instalment plan table in BIP publisher
Hi Guys,
I am working on BIP report which prints out data as follows:
Header and Lines comes from DB but product instalment plan is not available in DB. requirement is to calculate the Instalment plan on runtime (in BIP report )
- Instalment lines are always 10 (fixed)
- instalment amount for 10 lines is base on % provided in parameter
- instalment date is base on order date and add 1 month time interval for 10 lines to fill.
Header:
BuyerName: Buyer ID Order Date
Lines:
Product ID Product Name Product Amount
Product Instalment Plan:
Instalment 1 Date Instalment_amount Instalment %
Instalment 2 Date Instalment_amount Instalment %
.
.
Instalment 10 Date Instalment_amount Instalment %