Report Showing Users with No Logged Hours?

[Madalyn_Destafney]

Hi all, mental block here - I have an hour report for all active users grouped by user so I can see total hours logged by user, but what this wouldn't pull is any user that has ZERO logged time (ever, on any object). How can I pull this?

[ajdifonzo · Accepted solution]

Hi Madalyn, 

I have to give credit to @Doug_Den_Hoed__AtAppStore   for this one that I have saved.  This is not an hour report, but a user report with the following to that will return any Users with no hours entered in the past 7 days (for example):

EXISTS:a:$$EXISTSMOD=NOTEXISTS

EXISTS:a:$$OBJCODE=HOUR

EXISTS:a:entryDate=$$TODAY-7d

EXISTS:a:entryDate_Mod=gt

EXISTS:a:ownerID=FIELD:ID

Hope this helps. 

[Madalyn_Destafney]

It's beautiful! Thank you and thanks @Doug_Den_Hoed__AtAppStore !