Report based on a data using a "where in"-type query - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Steve BerleySteve Berley 

Report based on a data using a "where in"-type query

I have three objects,  Accounts, Contacts and Distributions.  Contacts and Distributions have no relationship to one another except they share a parent Account.

I need to report accounts and contacts who had distributions last month.  If I were creating SOQL, I'd write it as below.  
Select Account.Name, FirstName, LastName from Contact where AccountID in (select AccountID from Distribution__c where DistributIon_Date__c = last_month)
How do I accomplish this in the report builder?

Thanks,

Steve 
 
Adrienne CutcliffeAdrienne Cutcliffe
Hey Steve,
You could try to create a joined report for this, one for accounts with contacts, and the other accounts with distributions.
Steve BerleySteve Berley
Thanks!