function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Bob Poliquin 9Bob Poliquin 9 

Display monthly payments from record in visualforce pdf

I am trying to figure out if something is possible. I have a custom object that has a monthly payment field, number of months field, contract start date and end date fields.

what i need to do is display a monthly payment schedule on my visualforce pdf document But i not sure if this can be done. My screen shots below shows what I have built out but it is not dynamic at all.
When the Number of Months changes I need the VF document to display a payment for each month and the month of the payment as above. 

Below is a snippet of my visualforce code, but as I said it is not dynamic. I am looking for a better way to make this dynamic especially with the months btween the start and end contract dates. 

Any help would be greatly appreciated. A better solution earns a gold star 
 
<apex:outputPanel layout="none" rendered="{!IF(sbd.Number_of_Months__c >= 1 && sbd.Contract_Start_Month__c= 1 && sbd.IsSeasonal__c=true  ,true,false)}">
         <tr>
            <td style="font-weight:bold;border:1px solid black;
                            color:#000000;padding:1px;text-align:center;background-color:#dce6f1;font-size:10px;font-family:Times New Roman,  Helvetica, sans-serif;">10-Jan-20</td>
                            
                            <td style="font-weight:normal; border:1px solid black;
                            color:#000000;padding:1px;text-align:center;background-color:#ffffff;font-size:10px;font-family:Times New Roman,  Helvetica, sans-serif;width:40px"><apex:outputText value="{0, Number, Currency}"><apex:param value="{!sbd.Monthly_Payment__c}" /> </apex:outputText></td>

            <td style="font-weight:normal;border:1px solid black;
                            color:#000000;padding:1px;text-align:center;background-color:#ffffff;font-size:10px;font-family:Times New Roman,  Helvetica, sans-serif;"></td>
        </tr>
            </apex:outputPanel>

            <apex:outputPanel layout="none" rendered="{!IF(sbd.Number_of_Months__c >= 2 && sbd.Contract_Start_Month__c= 2 && sbd.IsSeasonal__c=true  ,true,false)}">
        <tr>
            <td style="font-weight:bold ;font-size:10px;font-family: Times New Roman, Arial, Helvetica, sans-serif;border:1px solid black;
                            color:#000000;padding:1px;text-align:center;background-color:#dce6f1">10-Feb-20</td>
            <td style="font-weight:normal ;font-size:10px;font-family: Times New Roman, Arial, Helvetica, sans-serif; border:1px solid black;
                            color:#000000;padding:1px;text-align:center;background-color:#ffffff"><apex:outputText value="{0, Number, Currency}"><apex:param value="{!sbd.Monthly_Payment__c}" /> </apex:outputText></td>
            <td style="font-weight:normal ;font-size:10px;font-family: Times New Roman, Arial, Helvetica, sans-serif; border:1px solid black;
                            color:#000000;padding:1px;text-align:center;background-color:#ffffff"></td>
        </tr>
            </apex:outputPanel>



 

View of the fields on the record
User-added image
User-added image