SPM Reports - Project

[Yuvaraj T]

Hi All,

I have requirement to create 2 reports.

Report :1

List all the projects which does not have a single status report?

Report:2 

List all the projects which does not have project task starts with some ket word. 

Example : completed, closed etc.

Is it possible to achieve without any coding? 

Your help is appreciated.. Thank you 

[AshishKM]

Hi @Yuvaraj T , 

Create database view on pm_project & status_report table for first report, and use that view in reporting on dashboard.

Create database view on pm_project & pm_project_task for second report, and use that view in reporting on dashboard.

-Thanks,

AshishKMishra

[Yuvaraj T]

Thanks Ashish for the suggestion.

I tried the same , but somehow not getting the data.

Do we need to use where clause and define fields in View field? 

If so can you please suggest how to use where clause? 

[AshishKM]

Hi @Yuvaraj T ,

Yes, where clause required in view mapping for matched record.

Share the view mapping screen shot.

-Thanks