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.

I have 2 custom objects(sales and service) which are related to accounts as a lookup and related to opportunities in a master detail.

i need to generate a report which shows under each account the list of sales and service records.

Not sure how i can build this relationship in report types

share|improve this question
add comment

2 Answers 2

You could do a joined report which is just two reports that have common fields. One would be Accounts with Sales and the other would be Accounts with Service Records. You can then group across both blocks with Account name.

share|improve this answer
    
Thanks Daniel.. Does joined report go along with conga composer? –  Prady Feb 15 '13 at 4:47
    
No, I don't think so. But, if you are using Conga, you can have two separate reports and pass both of them over to Conga for the merge. –  Daniel Hoechst Feb 15 '13 at 6:04
add comment

If I understand your data model correctly you should be able to do this with one soql query and conga has something called "conga queries" which allow you to pull data from stored soql queries that you write instead of reports.

I believe this is available as a private appexchange package and you will need to contact Conga about activating it in your org (there isn't any additional cost).

share|improve this answer
    
I do not think conga supports nested templates/ nested queries for the above model he needs to soemthing like select id,(select id from services__c),(select id from sales__c) from account limit 1. This is not supported by conga nor can u embed table within a table with different tablestart: and tableend:. If there is a way to nest up the data i would be more happier and thankful if ypu post a sample query/ implemenation –  rao Feb 15 '13 at 19:34
    
@rao You can't do sub-queries in conga queries but you can use tablegroups to split tables by a field value and then just create a formula field with the groupings you want (basically like a map<string,list<Sobject>>). Now that I re-read the post I may have misunderstood data model. Thought there was account.service__c and account.sales__c lookup fields. –  Greg Grinberg Feb 15 '13 at 19:56
add comment

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.