AnsweredAssumed Answered

Is there a way to only return a MAX set of values in Advanced Reporting

Question asked by malton on Mar 8, 2018
Latest reply on Mar 9, 2018 by Suman Pramanik

Hello CA PPM Community.  I'm on CA PPM v14.3 currently.  I'm looking to create a report in the standard (Ad Hoc) Advanced Reporting tool that will return the most recent (i.e. MAX) Status Report details, rather than the entire history of Status Reports.  Is this possible (not using Jaspersoft Studio), if so, any reference documentation on how best to accomplish?  Thanks!  Mark

 

E.G.

Project Name

Project ID

Project Manager

Max(Status Report - Created Date)

Max(Status Report - ID)

Max(Status Report - Status)

Max(Status Report - Comments)

Project ETC

Project Actuals

Outcomes