Yep, Doug is on the right track. I've been working a lot with EXISTS for the last few months and it really unlocks a lot of power. I wanted to do a talk on it at Leap, but alas it wasn't accepted. Jason Webre is doing a talk on the other half of the collection power block the nested syntax. EXISTS:a:$$EXISTSMOD=NOTEXISTS EXISTS:a:$$OBJCODE=ASSGN EXISTS:a:assignedToID=FIELD:ID EXISTS:a:status=AA AD EXISTS:a:status_Mod=in isActive=true isActive_Mod=eq So this looks for active users with no active assignments assigned to them. I usually create two reports when building these type of exists reports. A report on the object type that I'll use in the EXISTS to get things like Status, Teams, whatever figured out and simple filters for the object report I want. You can add the EXISTS block to the standard text mode for the report, so build out your user list to the group you want to check and then add the EXISTS. -- Melinda Layten, Senior Consultant Work Management Improvement CapabilitySource Phone: (484) 505-6855 site:
www.capabilitysource.com email: melinda.layten@capabilitysource.com Helpful? Buy me a coffee:
https://www.patreon.com/mlayten - we simplify your work so you can run your business -