Hi Ther,

I am trying to build a visualforce page which is rendered when a custom button on an opportunity page is clicked.

 The idea of the VF page is to have a table which lists all the opportunitylineitems(products) and opportunitylineitemschedules(quantity fiield).

I have been able to create this table in VF and have been able to succesfully show the lineitems and schedule quantity values in the page.However,what is happening now is that suppose an opportunitylineitem(product) contains three schedules,in the page i am getting three rows with product name and schedule quantity.What i want is that alongside this particular lineitem i should have these three lineitemschedule quantities in three columns in a single row instead of three rows.

Any help would be highly appreciated as this is an urgent requirement i have.Here's the controller code and VF page:

<apex:page standardController="opportunity" tabStyle="opportunity" extensions="mySecondController"> <apex:form > <apex:pageBlock title="opp line items" mode="edit"> <apex:pageMessages /> <apex:pageBlockButtons location="top" > <apex:commandButton value="Save" action="{!saveChanges}" rerender="main" status="ajaxStatus"/> <apex:commandButton value="Cancel" action="{!cancel}"/> </apex:pageBlockButtons> <apex:actionStatus id="ajaxStatus" startText="Updating line items..."> </apex:actionStatus> <apex:pageBlockTable value="{!mySecondController}" var="oli" columns="8"> <apex:column headerValue="Name"> {!oli.transcript.PriceBookEntry.Product2.Name} </apex:column> <apex:column > <apex:facet name="header"><b>QUARTER</b></apex:facet> <apex:inputField value="{!oli.trainee.quantity}"/> </apex:column> <!--</apex:panelgrid>--> <!-- <apex:column headerValue="Quarter2" footervalue="{!oli.Quantity}"> <apex:inputField value="{!oli.Quantity}"/> </apex:column> <apex:column headerValue="Quarter3" footervalue="{!oli.Quantity}"> <apex:inputField value="{!oli.Quantity}"/> </apex:column> <!--<apex:column headerValue="Quarter4" footervalue="{!oli.Quantity}"> <apex:inputField value="{!oli.Quantity}"/> </apex:column>--> <apex:column headerValue="Sum of Products per quarter"> {!oli.transcript.Quantity} </apex:column> <apex:column headerValue="Quantity" footervalue="{!total.quantity}"> <apex:inputField value="{!oli.transcript.quantity}"/> </apex:column> <apex:column headerValue="Sales Price" > <apex:inputField value="{!oli.transcript.UnitPrice}"/> </apex:column> <apex:column headerValue="LineDesc" > <apex:inputField value="{!oli.transcript.description}"/> </apex:column> </apex:pageBlockTable> </apex:pageBlock> </apex:form> </apex:page>

public class mySecondController { opportunity proj; opportunity []proj1; opportunitylineitem []oppli; opportunitylineitemschedule []o12; public opportunity tp { get; set; } public opportunitylineitem transcript { get; set; } public opportunitylineitemschedule trainee { get; set; } public mySecondController(opportunity tp1, opportunitylineitem trans1,opportunitylineitemschedule p) { tp = tp1; transcript = trans1; trainee = p; } public Opportunitylineitem total { get; private set; } public Opportunitylineitemschedule quart { get; private set; } public class myexception extends exception{} list<mySecondController> result=new list<mySecondController>(); list<mySecondController> result1=new list<mySecondController>(); public mySecondController(ApexPages.StandardController controller){ myexception e=new myexception('wromg feed'); this.proj = (opportunity)controller.getSubject(); proj1=[select id,amount_type__c from opportunity where id=:this.proj.id]; this.oppli=[select quantity,opportunityid,Id,PriceBookEntry.Product2.Name,UnitPrice,Description, PricebookEntryId from opportunitylineitem where opportunityid =:this.proj.id]; list<id>b=new list<id>(); for(opportunitylineitem o1235:this.oppli) b.add(o1235.id); this.o12 =[select scheduledate,quantity,id,opportunitylineitemid from opportunitylineitemschedule where opportunitylineitemid in:b]; this.total = new Opportunitylineitem(quantity = 0); this.quart=new opportunitylineitemschedule(quantity =0); list<id>list1=new list<id>(); try{ for(opportunity opportun:this.proj1){ if(opportun.amount_type__c=='One Time - Auto - Monthly'){ opportunitylineitem curTrans; for(Opportunitylineitem o3:this.oppli) { curTrans= o3; if((o3.quantity != null)) { total.quantity += o3.quantity; } opportunitylineitemschedule []olis10=[select scheduledate,quantity,id,opportunitylineitemid from opportunitylineitemschedule where opportunitylineitemid =:o3.id]; opportunitylineitemschedule curTrainingPath; list<opportunitylineitemschedule> li =new list<opportunitylineitemschedule>(); for(opportunitylineitemschedule olis:this.o12){ if(olis.opportunitylineitemid ==curTrans.id ){ curTrainingPath=olis; result.add(new mySecondController(opportun,curTrans,curTrainingPath)); } } } } } } catch(exception e1) { system.debug('<<<<<'+e1); } } public mySecondController[] getmySecondController() { return result; } public opportunitylineitem getol(){ return this.total; } public opportunitylineitemschedule get1ols() { return this.quart; } // Action Method called from page button public pagereference saveChanges() { upsert this.oppli; upsert this.o12; PageReference oppPage = new ApexPages.StandardController(this.proj).view(); oppPage.setRedirect(true); return oppPage; return null; } public opportunity getOpp() { return [select id, name,amount_type__c, (select id,PriceBookEntry.Product2.Name,Quantity,UnitPrice,Description,PricebookEntryId from OpportunityLineItems limit 5) from opportunity where id =:System.currentPageReference().getParameters().get('id')]; } }

Regards,

Suneil