How to create a report where the project with No task?

[VLee1]

How to create a report where active project has no task?

What is the condition (criteria) to set in report conditions?

Thank you.

[Sam Ogden · Accepted solution]

Hi,

In the report module there should be the option for 'related list conditions'.  In here select the related list that holds the project tasks and add condition where active = true.  Under the related list conditions change it to be 'No selected table records are related to a record on.  Screenshot is showing catalog tasks to request items as I don't have the ITBM module but should be same logic:

Let me know if this helps

Thanks

Sam

[dileepsingiredd]

Hi,

You could use below query on pm_project table to get all the projects without a child under it.

rollup=false 

Hope you don't have any customizations around rollup field.

Thanks,

Dileep

[VLee1]

Hello, which criteria I need add so that I can check how many of project without the project task?  Please provide me the dump screen how to do the setting. Thank you. 

[Sam Ogden]

Hi Vlee,

Just under the Related List conditions section, you can amended how this evaluates.  Your screenshot is showing 'greater than or Equal to 1' so it would show all project records where there is at least 1 Project task.

You need to amend this to 'No selected table records are related to a record' and include the filter condition.  In my screenshot below I just had the filter condition of Active | is | true .