I am using Person Accounts and have 2 custom objects: Ownership and Property.
The Ownership is a junction object and has 2 lookups: Account and Property.
I'd like to run a report with a filter that gives me unique Accounts where House.Type = 'Maisonette'. However when I run a report, I may get multiple Accounts because someone owns more than one Property which is a Maisonette.
Log in to share your answer and help other learners.
Log in to answerBest Answer · By JanBask Salesforce Expert
Answered on May 22, 2023
To eliminate salesforce duplicate report -
If I understand correctly, in SOQL you'd express your requirement more or less like that?
SELECT Id, Name FROM Account WHERE Id IN (SELECT Account__c FROM Ownership__c WHERE Property__r.Type__c = 'Maisonette')
It's perfectly doable with a cross filter.
Let's say I want to see Accounts that have at least 1 Contact with title = Director:
Here's how it looks on the "run report" page (note the icon)
Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.
Step-by-step Salesforce guides from industry experts
Common Salesforce interview questions, answered
Guides, tips and career advice on Salesforce from JanBask experts.
Salesforce How to Become a Salesforce Developer Without Experience
No coding background? Learn how to become a Salesforce Developer step by step - skills to build, projects to create, and how to…
Salesforce How to Become a Salesforce Admin With No Experience
No Salesforce Admin experience? Learn how to build real skills, create projects, and land an entry-level Salesforce Admin job…
Salesforce How Long Does It Take to Become a Salesforce Developer?
Wondering how long to learn Salesforce Developer? Most beginners need 6–12 months. See the study time, stage-by-stage roadmap and…
Salesforce How Long Does It Take to Become a Salesforce Admin?
Wondering how long to learn Salesforce Admin? Most beginners need 3–6 months. See the study time, stage-by-stage roadmap and…