SYSTEM STANDARDS > Reporting Options > JasperReports - Custom Report Upload

JasperReports - Custom Report Upload

Custom reports can be created using a third party application outside of eMRO called JasperReports. This application allows the user to create custom reports and import them into the Upload Custom Print window via the Settings module. Once the report has been imported, it will appear under that modules Print menu. Reports can be stored for later use or deleted once they are no longer needed. For information how to create custom reports, refer to the Jasper Studio help documentation.

Note: The functionality of this window has been updated to utilize JasperReport Server instead of Jaspersoft Studio. As such the details of this window have been updated in eMRO Version 5. See below.

This window is security controlled via Settings/ Update/ Upload Custom Print. For additional information, refer to the Security Explorer via the System Administration Training manual.

1. Access JasperReports

In order to create customized reports that can be imported into eMRO, a JasperReports account needs to be created and installed on a dedicated server. Once installed on the server, the JasperReports environment must be linked to the eMRO database.

Note: As mentioned in the eMRO Deployment Guide, a Dependency Software and Drivers Package is available for download here that includes JasperReport Server licensing, drivers, and deployment documentation.

Note: If a report already exists in eMRO and just needs to be modified, refer to Modifying Exiting Reports.

Once the JasperReport Server is installed, the JasperReports must be connected to the eMRO database in order to be able to create reports using said eMRO data. For more information on how to connect the eMRO database refer to Connecting Jaspersoft to the eMRO Database.

As reports are created in Jaspersoft, using the URL links to the direct report, these reports can be linked to eMRO Print windows.

2. Configure the eMRO Properties File

In order link the eMRO database to the Jaspersoft URLs, the following properties must be added to the datasource.properties file.

• Jasper Report Domain Name
• Jasper username
• Jasper password

For detailed information regarding the Jasper Variables to be set up in the eMRO datasource.properties file, refer to the eMRO Deployment Guide.

3. Link a Report to eMRO Modules

From the Upload Custom Print window in eMRO, the reports from Jasper can be linked to the desired module's print windows.

Prior to linking a Jasper report to eMRO, the URL for the specific report needs to be opened. From the Jaspersoft site select View list from the Reports section.

All reports that have been created in Jaspersoft should be listed here. Select the desired report to be linked to eMRO.

Information from the URL for the selected report will be required in the following steps.

From eMRO, go to the Settings/ Update/ Upload Custom Print window and select the New button.

The report can be accessible from eMRO, or from the eMobility web applications such as Production Control. If eMRO is selected, specify the Module and the specific Print Window where the report will be made available to users.

Enter the Report Name which will appear in the Print window and a Description.

To link the report in eMRO to the report in the Jasper app, the Parent Folder Uri and the Unit located in the URL of the Jasper report must be specified in the respective fields of the Upload Custom Print window.

The properties from the URL to be entered into the Uri and Unit fields includes everything in between the '=' and the '&' characters.

Select the Save button. The new print will be listed in the window.

Note: The Show On Dashboard checkbox allows users to view the custom print in the Dashboard Window. New custom prints are security controlled via the Security Explorer and will only appear in the Dashboard window if this checkbox is selected and the user has security access. For more information regarding the Show on Dashboard checkbox, please see eMRO Upload Custom Print, via the Settings/Update Menu module.

At this point the Security for the new print must be established per user. From the Security Explorer, ensure that the applicable users have access to the new print. (By default, users will not automatically have access to the new print.)

Users that have access to the print can now navigate to the print window and generate the print as required.

Select the new print, then select the Print button.

Note: The search fields at the top of the window will not be functional for custom reports. Any filters need to be applied directly in JasperReport.

Instead of a print being generated in the Print Queue, a new tab will open in the browser where the Jasper report window will be displayed.