Today, we need 4 separated reports in order to retrieve all the project information which is needed for some governance meetings:
- One based on pm_project table to get the project state, status and some attributes
- One based on the project_status table to get the last updated one for the project (1 record/ project)
- One based on the issue table to get the critical and last updated one for the project (1 record / project)
- One based on the decision table to get the critical and last updated one for the project (1 record / project)
Is there a way to combine the four SNOW PPM reports into one in order to get a report with 1 record per project with all the related information ?
I know that the standard reports are based on one table. But is there a workaround using database views for example?
Thanks
