Project_status (Status Report) and Pm_project (Project)

[dennisandrison]

HI

Does anyone know how to link these two tables together for reporting purposes?   I am being asked to pull the overall health status field from the related lists status reports from the project module and can not see how to do this.   Any help is appreciated.

Thanks

Dennis

[Jaspal Singh]

Hi Dennis,

You can report on Status Report (Project_status) table & then drill down to Project fields by clicking on the marked icon. Add necessary fields from Available too Selected column.

[dennisandrison]

Thanks are you saying

To build the report from the Project_status table and then I can drill back to the parent table?

Would I be able to set conditions for the report from fields from the project table or only the project status table?

Do you have any examples you can share?

[Jaspal Singh]

Kindly find my comments inline in red.

To build the report from the Project_status table and then I can drill back to the parent table?

Yes

Would I be able to set conditions for the report from fields from the project table or only the project status table?

You can set filter using both tables. Something as below.

Status Date is a field from Status report while Project-> Project fields helps us to access all project related fields.

[dennisandrison]

Okay thank got that report build

Filter is to show if project state is open or work in progress

However ran into a problem that I only need to show the most recent status overall health and all projects if they have a status or not

Running from this table project_status will not get me what I need, I think

What other options do you have to get this information with only showing the most recent status report for all projects with state in open or work in progress