I know this is a long shot, and I'm not well versed in the EXISTS filter yet, but I'm hoping someone can help.
Currently we have a proof approval report that shows proofs where the logged in user is a "reviewer and approver" and it's currently "Pending Review". Unfortunately this still makes a very long list for some of our users who are tagged on hundreds of proofs.
So I'm trying to get a shorter list where once the user has assigned themselves to the appropriate task on a project, then the proof that meets the above criteria (reviewer and approver and pending review) would show on said report.
I'm thinking a document version report using some form of the EXISTS filter could get there, but I'm not entirely sure.
Any ideas?