JasperSoft Report - When using "group by" Resource on the report "Investment Time and Estimate Review", the Investment names show as numbers instead of the Investment name

Article Id: 196108

Status: Published

Updated On: 28-07-2020 14:31

Products:

Clarity PPM On Premise

Issue/Introduction:

When using "group by" Resource on the report "Investment Time and Estimate Review", the Investment names show
as numbers instead of the Investment name

STEPS TO REPRODUCE:
1- Login to PPM 15.8.1 as a user with Access to Investments and Advanced Reporting
2- Go to "Home" > "Advanced Reporting"
3- Select the report: "Investment Time and Estimate Review"
4- Select individual values or "Select All" for each filter field
5- For the "Group By" selection drop down, select "Resource"
6- Click "Apply" and the Investment name will show an integer id instead of the name of the Investment

Expected Results: The "Investment Time and Estimate Review" report reflect the Investment Names

Actual Results: The "Investment Time and Estimate Review" report displays a number for the Investment Names

Workaround:
Group by: "Investment"

Environment:

Release : 15.8, 15.8.1

Component : CA PPM JASPERSOFT

DBMS: Oracle

Resolution:

Please reference DE56706