We have had a lot of requests from our sales/marketing teams and they all revolve around the same query.
"Provide a list of Accounts where they do not have a contract for X product"
This query would be "Active Accounts where they do not have an Active Contract Detail for Product X".
We have struggled to find a way to produce this via Advanced Finds/SSRS/PowerBI etc. Is there any way to do this? Any custom solutions?