Jump to content
Changes to the Jaspersoft community edition download ×

How to download an existing report from the JasperReports Server, and modify the query that is used by the report?


Se0346

Recommended Posts

I am completely new to Jaspersoft. I have been working in Microsoft SSRS for some years. Today, our company's 
IT team has a task for me in Jaspersoft. They want to fix this immediately.

 

I have been given this link by the IT team:

http://xx.xxx.xxx.:8080/jasperserver/flow.html?_flowId=searchFlow

 

We have an existing report called TimeSheet that is scheduled to run everyday and this report is generated and sent via 
email to the managers every working day. The IT team needs to make a minor modification in the report so that 
all the employees are shown in the report regardless of whether the employees are present or absent. (Currently only those 
employees who are present are shown). This solution can be a simple one such as changing an INNER JOIN to a 
LEFT OUTER JOIN. I am told that a simple MySQL database contains the data for this report.

 


I have the following tasks before me:

1) I need to get into the existing Timesheet.jrsml (report) file in the Jaspersoft server

2) Then look into the query or stored procedure that runs this Timesheet report.

3) Modify the query and create a new Timesheet report that can be scheduled.

4) Deploy this new report into the server and schedule it.

5) Once the data is verified in the new report, the old report can be deleted.

 

 

The challenges I have are:

1) I find the Timesheet report in the TIBC Jaspersoft server (a web link). Is there a way I can download 
the existing Timesheet.jrsml file ?

2) How do I get the queries/ stored procedures that run this report?

 

 

When I right click the Timesheet report and go to Edit, I see the following:

Set up tab: I see a Read-Only resource ID called XYZ. Where do I find this resource ID called XYZ?

Datasource tab: I see a JDBC data source that exists in the Repository

Query tab: I see the 'Do not link query' chosen

Customization tab: None

 

 

More importantly, do I need to install tools such as Jaspersoft Studio, iReportDesigner etc locally in my 
machine to do this modification? Or can I do this change using the web browser link the IT team has provided:

http://xx.xxx.xxx.:8080/jasperserver/flow.html?_flowId=searchFlow

In the above link, I find the following:

1) root

  i)Reports

     a)Deployed Reports Folder

     b)Interactive

     c) some folders specific to our organization


I do not find the following under root folder:

  (ii) Analysis Components

  (iii)Content Files

  (iv) Data Sources

  (v) Images

  (vi)Themes

How to download template from JasperReports Server and modify it?

Link to comment
Share on other sites

  • Replies 5
  • Created
  • Last Reply

Top Posters In This Topic

You need jaspersoft studio to edit the report. 

Once you install the jaspersoft studio, you need to configure the report server in the Repositories section of the tool. 

Once this is done, the folder structure will be visible in the jaspersoft studio and then you can access the jrxml. 

 

The other way is to Export the Report by right clicking on the report in Jasper Server and click Export (need proper permissions). Edit the SQL conditions and use js-import batch scripts/Server UI to import the jrxml and xml files into the jasper server.

The second option will not work if you want to modify the report layout since the fields from SQL will not be evaluated at the run time. 

http://community.jaspersoft.com/documentation/jasperreports-server-administration-guide/v550/import-and-export-through-web-ui#import-export_2353750880_1044705

Link to comment
Share on other sites

Hello reportdev,

 

I have installed the Jaspersoft Studio. I am able to connect to our server, and have made a copy of the report, and have made some changes.

Now a quick question: How to deploy/publish this new report I have created into the server ?  

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...