Thanks to the help from a 2011 post (special thanks to contributor bob_buzzard)I was able to successfully create 2 Visualforce pages that work together to display a related list that is 2 relationships away. Page1 passes a value to Page2, Page2 then gets the field data from the related list and passes the list back to Page1 via the use of iFrame. The pages work perfect!, I simply launch Page1 from the Object. However my real need is to get the list on Page1 into a Visualforce email template. I am on Group Edition which unfortunately only allws Standard Controllers. Can this be done? I have spent more hours on this than I care to admit, any help would be appreciated. Below is my code:
 

Page1:
<apex:page sidebar="false" title="List" showHeader="false" standardController="Case">  
   <apex:outputText value="{!Case.Job_Name__c}" rendered="false" />
   <apex:iframe src="/apex/Page2?id={!Case.Job_Name__c}" />
</apex:page>


Page2:
<apex:page sidebar="false" showHeader="false" standardController="Interior_Job__c">
   <apex:dataTable value="{!Interior_Job__c.SSV_Link__r}" var="d">
  <apex:column headerValue="Vendors List" value="{!d.Vendors.Name}"/>
   </apex:dataTable>
</apex:page>

 

I have a lookup field on Case object that links to a Custom object. The Custom object has a related list of Cases down below but I need to pull up to the Custom object record some totals from the Cases. Obvisly not possible with Roll-up field since the relationship is not Master-Detail. Is this possible with Visualforce "standardController="Custom_Object__c"? Something like I would code if the relationship was Master-Detail?

                                    <apex:outputText value=" ${0, number,###,##0.00}">
                                    <apex:param value="{!Custom_Object__c.Case.Case_Field__c}" />
                                    </apex:outputText>

Any help woul be appreciated- I am at a dead end.

I have a lookup field on Case object that links to a Custom object. The Custom object has a related list of Cases down below but I need to pull up to the Custom object record some totals from the Cases. Obvisly not possible with Roll-up field since the relationship is not Master-Detail. Is this possible with Visualforce "standardController="Custom_Object__c"? Something like I would code if the relationship was Master-Detail?

                                    <apex:outputText value=" ${0, number,###,##0.00}">
                                    <apex:param value="{!Custom_Object__c.Case.Case_Field__c}" />
                                    </apex:outputText>

Any help woul be appreciated- I am at a dead end.

 

This is my VF code:

 

<apex:dataTable value="{!Order__c.Opportunity__r.OpportunityLineItems}" var="d">
	<apex:column headerValue="Desc" value="{!d.Description}"/>
</apex:dataTable>

 

I am receiving an error: Error: Aggregate Relationship is used in an unsupported complex expression containing 'opportunity__r.opportunitylineitems'

 

 

Order__c is a custom object which has master-detail relationship with opportunity. I am trying to display the OpportunityLineItem details in a VF page on click of a button(Generate Order, present in Order detail page).

 

Can anybody explain whats wrong?

 

I have 4 fields - Category1, Category2, Category3, Category4

 

I have created a formula field which concatenates all these into 1 single field and shows in the new field called TotalCategories

 

Total Categories = "Category1:" & Category_1__c & ";Category2:" & Category_2__c & ";Category3:" & Category_3__c & ";Category4" & Category_4__c

 

This is absolutely fine. But when only Category1 is filled.. Total Categories should show only Category1:"Category_1__c". Can anyone help .. how to do ? I tried using 'Case' but no use.

Message Edited by DalStar1999 on 07-25-2008 02:32 PM

Message Edited by DalStar1999 on 07-25-2008 02:34 PM

Message Edited by DalStar1999 on 07-25-2008 02:50 PM