+ Start a Discussion

how to get fields of child of a lookup in a report?

I have created an object "ABC" it has a lookup to the Opportunity. Now i am creating a Report on Opportunity but I am not able to access the fields of object "ABC". What is the way to get access of the fields of "ABC" from Opportunity in a Report?

see quer: Map optyrecord=new Map(Select Id, StageName,(Select col1__c,Col2__c from ABC__r) From Opportunity); use like above map query. and use Map methods like. Opportunity oprec=optyrecord.get(opid); for(ABC__c abc:optyrecord.ABC__r){ } use like as above example.