CA PPM: Custom Jasper Report Returns No Data When Run from Reports and Jobs

Document ID : KB000100394
Last Modified Date : 11/06/2018
Show Technical Document Details
Issue:
We have a custom Jasper report, created in Jasper Studio, which has several parameters on it. We would like to run the report from the Reports and Jobs section of PPM, and thus we have set up a definition for it and mapped all the parameters. However, whenever we attempt to run the report from the PPM Reports and Jobs section, it does not return any data. If we run it from Jasper directly, it does return the correct results.
Environment:
CA PPM 15.3 and above
Cause:
The problem was caused by the fact that the report has a parameter for filtering by Active, Inactive, or ALL records. When this parameter is left blank, in Jasper Studio it would pass the empty square bracket "[]" and it takes the count when no value is selected. However, when running the report via the Reports and Jobs section in PPM, no value is taken for that field, thus it passes a "NULL" to the report, and no data is returned. 
Resolution:
To resolve this, make the parameter for "Active" required, so that it forces you to select a value, thus it will not pass a "NULL" value to the report, and this way the proper data will return.