Is there a way to create a task report that won't show tasks that have issues that are not complete?

[Dusty_H]

I have a task report to show all open (not cancelled, on-hold, or completed) tasks.  we are looking to add requests to these tasks that another team would process.  Once complete we want the tasks to show in our report to show that the task can be processed.

is there a way to filter a task report to not show tasks with open (Status not set to  "Completed" or "Cancelled") requests?

[Sven-iX · Accepted solution]

Yes. A task has a collection called numberOpenOpTasks so in your filter you can add "numberOpenOpTasks=0"

[Dusty_H]

exactly what i needed!  thank you!