I am trying to maka a view that finds all cases without any activities e.g. 
service activity, call etc.

I tried several cobinations but not succeed.

Any ideas?

thanks!

Perttis,

You really can't, at least not using Advanced Find.  If you're good
with SQL, you can write a SQL query that does a left join of the case
table to the activitybase table, but that still won't allow users in
CRM to do anything with the results (like create activities for them).
But, you can tie an SRS report to a SQL query or stored procedure that
can get you that info, so that's one way to go.

The only add-on I've found that will let you do this within CRM is
c360's Audit product.  The Audit Analyzer component will let you easily
create such a view.  You can even link in workflow so that a user could
run that query, and then run a workflow to create a task (or any
activity) for all of those cases.  HTH,

Dave

Perttis wrote:
> I am trying to maka a view that finds all cases without any activities e.g.
> service activity, call etc.
>
> I tried several cobinations but not succeed.
> 
> Any ideas?
> 
> thanks!