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]

In that case you can get a database view created as below to get what is expected.

[dennisandrison]

Thanks but there was nothing showing the database view in your response

Can you resend

[dennisandrison]

Thanks got the view built but how do I pull this into the report?

[Jaspal Singh]

Go to Reports >> Create New. Look for table created with name Project status report & then report with appropriate filters.

[dennisandrison]

Am I searching for a table with the name of the database view I created with these joins? If so I tried and the system did not find any tables with my name.

Is there something else I need to do to the database view prior to it being visible in the reports?