AnsweredAssumed Answered

Duplicate rows returning with Status Report information

Question asked by William O'Connell on Feb 4, 2016
Latest reply on Feb 5, 2016 by suhail-sayed

We are using CA PPM 14.2 for project management. We utilize many fields in the system for reporting, including all  Status Report fields (Status Report date, Status Report Update, Report Date, Overall Status, etc...) for some project reporting. When producing a basic project report with status report information, the system always returns multiple rows per project as Advanced Reporting is taking all instances of a status report within that project (i.e. Project ID 0001 has four status reports logged, all with different verbiage and different dates in the Report Date column. This report returns all status reports because we are using the Report Date as a field.) Is there any way from with Advanced Reporting to get a report to return only the latest status report for a project?

Outcomes