AnsweredAssumed Answered

List of Baselline changes for a project

Question asked by Shiva_Rxm on Feb 11, 2014
Latest reply on Apr 21, 2014 by Ly_Yang_CA_Titres

Hello All,

I have been tasked with creating a report through BO or Crystal reports in order to list all changes to baselines from the start of a project to end of the project. I have observed that there are couple of tables in Clarity (PRJ_BASELINE_DETAILS and PRJ_BASELINES) which retain this information.

Please could you throw pointers on how this can be achieved? I have tried this query in Crystal Reports but without much luck:

SELECT INV_INVESTMENTS.BASELINE_ID, INV_INVESTMENTS.ID, INV_INVESTMENTS.NAME, PRJ_BASELINES.CODE, PRJ_BASELINES.DESCRIPTION, PRJ_BASELINES.IS_CURRENT, PRJ_BASELINES.NAME, PRJ_BASELINES.PROJECT_ID
FROM INV_INVESTMENTS
INNER JOIN PRJ_BASELINES
ON INV_INVESTMENTS.ID=PRJ_BASELINES.PROJECT_ID
 
Am I missing something? Please help.
 
Regards,
 
-S-
 

Outcomes