function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Again AgainAgain Again 

Report to show all accounts with no contacts

I need to report on all accounts of a certain account type, with no contacts of a certain markup. If I were constructing a SQL query, I'd say something like
select account.accountname
Recordtype  = 'xxx'
AND ID NOT IN (select AccountID FROM Contact WHERE Contact.Status = 'yyy')
How can this be done in SalesForce / with a related tool?
Get DBAmp and enter the sql statement just like you have it.

Relational Junction can give you a data warehouse for reporting on any DBMS platform. The database query would then be

  Select * from taccount
  where not exists (select 1 from tcontact where tcontact.accountid =

Relational Junction is a complete solution for all your reporting and integration needs which provides 2-way replication from a mirror-image warehouse. It is also platform neutral. We support Oracle, SQL Server, DB2, MySQL, and Sybase, and run on Windows and Unix platforms.


Again AgainAgain Again
Thanks - I'm downloading the trial and will give it a bash!
Again AgainAgain Again
I had a look and it looks really nice, but I think I'll have to wait until our SF implementation is more settled in before I'll be able to justify the price tag. :smileysad:  I will keep an eye on it though. Looks like it could save lots of time in the long run.
Again AgainAgain Again

I've been using DBAmp and it's really nice. Thumbs up!

I get an error when I try to get the value of a multi-select picklist. Is there a special way to access this data?