current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It's 100% free, no registration required.
up vote 2 down vote favorite

Im trying to display the below format using a visualforce page.

Particulars    Receipts     Date           Amount Received  Amount paid

OnBooking                   29-Oct-2012    12000            0
               rec1         12-Oct-2012    0                23000
Agreement                   29-Oct-2012    13000            0
               rec2         13-oct-2012    0                1200

Particulars belongs to one object and receipts belongs to another object. Amount received is the field in particulars, and amount paid is the field in recipts. Currently thse two objects are related to opportunity. Im trying to use repeat functions inside repeat.

<table width="100%" border="1" cellspacing="0">
    <tr>
        <td colspan="11" align="center" style="font-size:15px; font-weight:bold;">SCHEDULES</td>
    </tr>
    <tr style="font-size:14px; font-weight:bold;">
        <td> Particulars </td>
        <td> Receipt No</td>
        <td> Due Date </td>
        <td> Amount Due </td>
        <td> Amount Received </td>
    </tr>         
    <apex:repeat value="{!psList}"  var="ps">
        <tr style="font-size:14px;">
            <td>{!ps.Name}</td>
            <td></td>
        </tr>
        <apex:repeat value="{!rcList}" var="rc">
            <tr style="font-size:14px;">
                <td></td>
                <td><apex:outputfield value="{!rc.Name}" rendered="{!rc.Payment_Towards__c ='On Booking'} || {!ps.Name=='On Booking'}"/>
                 <!-- <apex:outputfield value="{!rc.Name}" rendered="{!rc.Payment_Towards__c ='Agreement Signing'}"/>
                 <apex:outputfield value="{!rc.Name}" rendered="{!rc.Payment_Towards__c ='Excavation'}"/>
            </td>
            <td>
                <apex:outputtext value="{0,date,dd-MMM-yyyy}">
                    <apex:param value="{!ps.Due_Date__c}"/>
                </apex:outputtext>      
            </td>    
            <td>  
                <apex:outputtext value="{0,number,###,###,###,##0.00}">     
                    <apex:param value="{!ps.Total__c}"/> 
                </apex:outputtext> 
            </td>
              <td>  
                <apex:outputtext value="{0,number,###,###,###,##0.00}">     
                    <apex:param value="{!ps.Payment_Received__c}"/> 
                </apex:outputtext> 
            </td>
        </tr> 
    </apex:repeat>     
</table>

How can I generate this visualforce page, can I use repeat inside repeat? The values for the second list are always the same.

share|improve this question
    
Using a repeat inside a repeat is fine, are you experiencing problems with your page? –  LaceySnr♦ Oct 30 '12 at 6:19
    
Yes.But i cannot display above mentioned format.The second list values are repeating . –  user958915 Oct 30 '12 at 6:32

2 Answers 2

up vote 7 down vote

Your problem is that you want to interleave two lists, or list the children for each parent, but your inner repeat is always binding to the same list variable in the controller, it's not changed for each parent record.

The cleanest solution here would be to use a wrapper class in your controller like so (note that I'm guessing you have 1 Particular to Many Receipts, and guessing at the object names).

public class TableEntry
{
    public Particular__c particular {get; set;}
    public list<Receipt__c> receiptsList {get; set;}

    public TableEntry(Particular__c p)
    {
        particular = p;
        receiptsList = new list<Receipt__c>();
    }
}

You build up a list of these entries in your controller code:

// declaration
public list<TableEntry> particularList {get; set};

** SNIP **

// inside some method where you have the data (pseudo code!)
for(Particular__c p : particularQueryResults)
{
    TableEntry e = new TableEntry(p);

    for(Receipt__c r : mapParticularToResults.get(p.Id))
    {
        e.receiptsList.add(r);
    }
}

Then finally, in your page you can use nested <apex:repeat> tags, one which loops through the list of TableEntry objects, and one that loops through the Receipts in each:

<apex:repeat value="{!particularList}"  var="ps">

    <!-- Reference the particular member when you need the fields for that -->
    <tr style="font-size:14px;">
        <td>{!ps.particular.Name}</td>
        <td></td>
    </tr>

    <!-- Now reference the receiptsList for the current Table Entry -->
    <apex:repeat value="{!ps.receiptsList}" var="rc">
        <tr style="font-size:14px;">
            <td></td>
            <td><apex:outputfield value="{!rc.Name}" rendered="{!rc.Payment_Towards__c ='On Booking'} || {!ps.Name=='On Booking'}"/>
            <!-- etc. -->

You haven't posted your controller code, so a lot of this is stabs in the dark, but it demonstrates a method in which you can achieve what you want. Of course, if there's only one receipt per particular then you won't need a list inside the class or the nested repeat, you'd just use {!ps.receipt.<<fieldname>>}.

share|improve this answer
up vote -1 down vote

Yes, you can use a repeat inside a repeat.

share|improve this answer
    
I believe an example code is expected. Just saying something is or isn't - lacks the point of answering. –  Saariko♦ Oct 30 '12 at 8:48
2  
Fair down vote, guess a crappy question doesn't give license for crappy answers. –  Ralph Oct 31 '12 at 2:19

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.