A report of RITMS where the owner of the RITM has no Tasks assigned to them

[ChicagoRus]

I'm looking for a way to create a report of RITMs where the owner of the RITM does not own any of the catalog tasks (SCTasks).  I tried using [sc_req_item] as the table and dot walking to assigned to and that didn't work.  I tried from the RITM and Task table and those didn't work.    Anyone have any ideas?  

[Dr Atul G- LNG]

Hi @ChicagoRus 

Try in reverse side, create report in Sc_task table and dot walk to RITM.

[JenniferRah · Accepted solution]

Is this what you mean? Basically, you want all active RITMs where the Assigned to person in the RITM doesn't have any tasks Assigned to them?

[ChicagoRus]

Thank you!

[ChicagoRus]

Thank you both for responding so quickly.  AG - I tried going the other direction (from SCTask) but it didn't work.
Jennifer - I want RITMS where the assigned to of the RITM has no tasks assigned to them from that RITM.  (They own the RITM, but don't own any of the work.)  I tried changing your example to "Is different from" but unfortunately no go.