ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Error when attempting to run a report from Jasper Studio

book

Article ID: 8631

calendar_today

Updated On:

Products

SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service CA Service Desk Manager CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

When attempting to open a report in Jasper Studio, and then run that report, an error may pop up as follows:

<Please see attached file for image>

1.PNG

Cause

This is caused by Jasper Studio not having some of the files that make up a report locally available on the machine.

Environment

CA SERVICE MANAGEMENT - R14.1.x, R17.x and UP

Resolution

In order to run a report from Jasper Studio, you must first download the report into Jasper Studio, and then you can run the report. 

To do this, follow these steps:

The following are the steps to download, compile and run the reports in Jasper Studio.

 1. Firstly click on the Project Explorer tab

 2. Then Right Click on MyReports and select New-> Folder and give the folder a name (e.g. MyTestReports)

 3. The go to the Repository Explorer tab and navigate to the Service Desk reports. In this example we'll use the 'Active Incidents Aging'

 4. Expand the 'Active Incidents Aging' report - you'll see 4 sub-components (main_jrxml, active_incident_aging_subreport.jrxml, ca_styletemplate.jrtx and Resource_Bundle_en_US.properties)

 5. Right click on each of these components and select 'Download to File'. When the Save As popup appears, select MyReports-> MyTestReports as the destination.

 6. Once all the components are downloaded, in the Project Explorer tab open the MyReports-> MyTestReports main_main.jrxml file

 7. Click on the Data Set and Query Editor dialog button (Top Right of middle pane) and click the Drop down in the top left (It will probably say 'One Empty Record'). Select the Service_Desk_Data_Adpapter and then OK.

 8. Now click on the Compile Button - to the left of the Data Set and Query Editor button.

 9. Once the report compiles, click the preview button in the lower middle pane - This should run the report.

You can then edit and compile the .jrmxl files while working in Jasper Studio, and once you are happy with the report, you can publish it back to Jasper Server to make it available for users.

TIP: We recommend that you create a new folder on the server to save your customized reports, as well as change the name of the report, so that you do not risk overwriting the OOTB reports.

Attachments

1558700754680000008631_sktwi1f5rjvs16p6q.png get_app