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:
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:
In the above link, I find the following:
a)Deployed Reports Folder
c) some folders specific to our organization
I do not find the following under root folder:
(ii) Analysis Components
(iv) Data Sources
How to download template from JasperReports Server and modify it?
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.