• swapna sree 3
  • NEWBIE
  • 10 Points
  • Member since 2017

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 3
    Replies
write a child to parent query on opportunity and opportunity line item
Hi Guys,

I'm creating a report with 'Opportunity and opportunity team'. I need to display a specific role as a column in the report.
Ex. one of the team member role is 'Sales manager'
my report should have columns like- opportunity name, sales manager,created date

How can i display only 'Sales manager' role in the report. 
I am trying my first attempt at Visualforce pages.  I found a sample online and it works fine, but when I change it to use my custom objects, it fails. Here's what I have and getting an error on the page saying "Unknown property 'dataTableLanes.lanes'.  It clearly exists.  What am I missing?

The Class:
public class dataTableLanes {
    List<Lane_Detail__c> lanes;
 
    public List<Lane_Detail__c> getLaneDetails() {
        if(lanes == null)
            lanes = [SELECT Destination_City__c, Destination_States__c FROM Lane_Detail__c LIMIT 10];
        return lanes;
    }
}


The Page:

<apex:page controller="dataTableLanes" id="thePage">
    <apex:dataTable value="{!lanes}" var="lane" id="theTable"
        rowClasses="odd,even" styleClass="tableClass">
        <apex:facet name="caption">table caption</apex:facet>
        <apex:facet name="header">table header</apex:facet>
        <apex:facet name="footer">table footer</apex:facet>
 
        <apex:column>
            <apex:facet name="header">Name</apex:facet>
            <apex:facet name="footer">column footer</apex:facet>
            <apex:outputText value="{!lane.Destination_City__c}"/>
        </apex:column>
 
        <apex:column>
            <apex:facet name="header">Owner</apex:facet>
            <apex:facet name="footer">column footer</apex:facet>
            <apex:outputText value="{!lane.Destination_States__c}"/>
        </apex:column>
 
    </apex:dataTable>
</apex:page>