Advanced Reporting : Create a Report with Jaspersoft Studio/jrxml file based on Domains : returns no results, when Ad-Hoc Views do

Document ID : KB000033260
Last Modified Date : 14/02/2018
Show Technical Document Details

Symptoms:

Creating a custom report with Jaspersoft Studio, based on Domains does not work, no results are returned by the report. Same columns added to Ad-Hoc Views retrieve correct results. If the custom report is not Domain based, there is no issue.

Environment: 

This issue is encountered only with CA PPM 14.3, CA PPM 14.2 is not affected.

Cause:

This is due to a known issue in CA PPM 14.3:

CLRT-79228 Create a Report with Jaspersoft Studio/jrxml file based on Domains : returns no results, when Ad-Hoc Views do

Steps to Reproduce:

  1. Log in to Jaspersoft UI Console as admin user
  2. Navigate to Repository : <tenant> - CA PPM - Reports
  3. Right click on Reports folder - select Add Resource - JasperReport
  4. Enter the Report name, for example Test3
  5. Select Upload a Local File - browse and attach the file attached Blank_A4_5.jrxml
  6. Now click on Data Source button
  7. On the Data Source page, choose Select data source from repository
  8. Browse to <tenant> - CA PPM - Domains
  9. Select Investment Management Domain
  10. Click on Submit
  11. Now connect to Clarity UI - Advanced Reporting - Reports List
  12. Find the Test3 report - click to run

Expected Result: Report to display results 
Actual Result: The report is empty 

Note : These are the steps to reproduce the issue with the file: Blank_A4_5.jrxml. The same result is also reproducible with Jaspersoft Studio.

Resolution:

CLRT-79228 is in review with our Sustaining Engineering team.

 

File Attachments:
TEC1744198.zip