I'm building a report to show all accounts without open activities.
It's:
-
Accounts with or without related records from Activities
-
with filter activity status equals Completed.
I don't understand. In the report there are also accounts with activity with status not equals to completed.
Do you Know why?
UPDATE TO THE QUESTION:
Now it works and i want that each account appears just one time in the report(See in the picture Grand Hotel..).
This account hasn't open activities but it has 2 closed activities.
Do you Know how archive this?
Thanks in adavantage for any advice.
Best Answer
You can do this with the new Cross Filter feature, described here and here's a short demo.
The report would start with the standard Accounts report, then you'd add a cross filter for "without Activities", and even further define filters on the Activity object.
It will look like this when you're done: