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

Products

• CLARITY PPM FOR ITG
• CLARITY PPM FEDERAL
• Clarity PPM SaaS - Application
• Clarity PPM On Premise

Issue/Introduction

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.

 

Environment

Release: ESPCLA99000-14.3-Clarity-Extended Support Plus
Component: