
We're trying to create a report which shows all active opportuntites and their candidate slates.
For each opportunity we can have a slate of candidates. The slate record has a custom field with a data type of Lookup(Person). There is also a custom field with a data type of Lookup(Opportunity). We've created a report type which has a relationship of Contacts (A) with at least one related record from My Slates (B). But I also want to add a relationship with the Opportunity record and it's not available. I've tried coming at this from multiple directions. For example opportunities with slates with contacts or opportunities with contacts with slates and can't seem to make it work right. Any help would be greatly appreciated.
TIA,
Mitch
6 件の回答
I am re-reading your original question and trying to figure out what the actual report type is that you need.
You want All Active Opportunities with Candidate Slates. By this statement, the report should be an Opportunities with Slates. However your description paragraph eludes to wanting to see Candidates with Slates. There is no direct (lookup or master-detail) relationship between Cadidates and Opportunities, right?
Try this: Create an Opportunities with Slates report type. When you get to the Field Layout Properties screen, in the right hand box, select Slate fields under View. Then click the Add fields related via lookup » hyperlink below the picklist box. Select Candidate (or Contact or whatever). Can you add in the fields you want, to achieve the report your goal is to create?