How to filter a Proof Approval report based on task status where a task level custom attribute is of a certain value?

[KevinMei]

We have a task level custom field named "Sub Milestone" (internal reference is DE:tasks:Sub Milestone). We would like to create a Proof Approval report to find any proofs that belong to projects where DE:tasks:Sub Milestone=MARKETING APPROVED and that task's status is completed (CPL). I assume we'll probably have to traverse the hierarchy all the way up to its project and then back down to task level. I'd really appreciate any suggestions on how to accomplish that.

[WhitUser]

Hi - did you ever find a resolve to this isse? Because as i understand it, I have pretty much exactly the same query..