How to eliminate duplicate records in a report?

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.

Any help please?

Answer

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:

enter image description here

Here’s how it looks on the “run report” page (note the icon)

enter image description here

Attribution
Source : Link , Question Author : cyorkston , Answer Author : eyescream

Leave a Comment