I am trying to build a report on Accounts:
Existing Configuration: Contact entity have a fields called Security Info(Text field). And Contact Group (Lookup)
Report criteria: Report should display all Accounts where its related Contact's "Security Info" field does not contain "T+O" and Contact Group does not equals "SAT" & "TUP"
Report should not include any Account if anyone of its contacts fits into this criteria.
Note: T+O is a text used for certain Security indication and SAT and TUP are group names.
Can some one help me with the query for this report?
*This post is locked for comments