Dhiraj Pahlani

Problem: Currently, if we export a JasperReports table to PowerPoint format, interactive or not, each value is an individual element. We would like the table to become a real PowerPoint table so that we can manipulate it exactly as if the table is created from PowerPoint. How to achieve this requirement? Solution: With JasperReports Server 9.0.0, we can export JRXML reports as real DOCX and PowerPoint tables instead of individual cell elements. It is recommended to upgrade to this current latest version of the product to achieve the above mentioned requirement. Attaching one .docx file and one .pptx file exported from a 9.0.0 instance for reference. ________________________________________________________________________________________________________________________ Ref. Case #02249429 Table_PPTX.docx Table_PPTX_new.pptx

Problem: We are exporting reports to Excel file for further analysis using formulas. However, the exported file stores number as text. Is there a way to retain the type of the cell? Solution: We can set the below property at the report level to retain the cell type in the exported Excel file. net.sf.jasperreports.export.xls.detect.cell.type=true The same property can also be set at the global level by adding the property in the jasperreports.properties file (<jasperserver-pro>/WEB-INF/classes/), saving the changes, and restarting the server for the changes to reflect. Attached excelReport.jrxml report is a sample report which can be run using the Foodmart database, and its exported Excel file, excelReport.xlsx, for reference. ______________________________________________________________________________________________________________________ Ref. Case #02250326 excelReport.jrxml excelReport.xlsx

Requirement: We have a requirement to read data from Redis server, but we don't see any connectors or transformations related to it. Can you please suggest how can we do this? Solution: It seems that some JDBC driver exist for REDIS : https://www.cdata.com/drivers/redis/jdbc/ So, using this driver you can use the tJDBC* components to access the REDIS server. https://help.talend.com/r/en-US/8.0/jdbc/jdbc __________________________________________________________________________________________________________________________ Ref. Case #02217220

Problem: Some jobs are configured in JasperReports Server for sending reports as mails. Sometimes its results in error without sending the mail. 2023-10-26T07:00:04,709 ERROR ReportExecutionJob,JasperServerScheduler_Worker-2:457 - The job error notification was not completed. An error occurred while sending it. org.springframework.mail.MailSendException: Failed messages: com.sun.mail.smtp.SMTPSendFailedException: 451 #4.3.0 Server Error ; message exception details (1) are: Failed message 1: com.sun.mail.smtp.SMTPSendFailedException: 451 #4.3.0 Server Error How can we resolve this error? Cause: SMTP error 451 usually indicates when the user exceeds the limits set on the email server for sending emails. The email server will not allow the user to send more emails than the limits set on the email server; these limits are set as daily or hourly limits. Solution: Please check this with your email server administrator and confirm if such an email limit is set on the user sending scheduled emails from Jaspersoft to resolve this error. ________________________________________________________________________________________________________________________ Ref. Case #02218881

Requirement: To add the Plain Text exporter to the Report, Ad Hoc, and Scheduler exporters list. Solution: In a 8.0.4 installation, Steps needed to enable Plain text exporter to Report: Navigate to the WEB-INF/flows/viewReportBeans.xml file. Uncomment entry for key txt,“<entry key="txt" value-ref="txtExporterConfiguration"/>” in the exporterConfigMap bean. Navigate to the /WEB-INF/applicationContext-remote-services.xml. Uncomment entry for txt, <entry key="txt" value-ref="remoteTxtExporter"/> in the remoteExportersMap bean. Steps needed to enable Plain text to Ad Hoc: Navigate to the /WEB-INF/applicationContext-adhoc.xml. Uncomment entry for key txt “<entry key="txt" value="jasper.report.view.hint.export.txt" />” in the exportFormatLabels bean. Steps needed to enable Plain text to Scheduler: Navigate to the WEB-INF/flows/reportJobBeans.xml. Uncomment the following bean <bean class="com.jaspersoft.jasperserver.war.dto.ByteEnum"> <property name="code"> <util:constant static-field="com.jaspersoft.jasperserver.api.engine.scheduling.domain.ReportJob.OUTPUT_FORMAT_TXT"/> </property> <property name="labelMessage"> <value>report.output.txt.label</value> </property> </bean> Navigate to the /WEB-INF/applicationContext-report-scheduling.xml. Uncomment entry for TXT , <value>TXT</value> in the availableReportJobOutputFormats bean. Uncomment entry for txt, <entry key="txt" value-ref="jobTxtExportParameters"/> in the jobExportParametersMap . After restarting the JasperReports Server, The “Text only" exporter should be available to the list of exporters for Report and Ad Hoc. In Scheduler we will able to see Plain Text(.txt) option in the list of formats.

Requirement: We need to remove the default double quotes in our CSV exported files, how can we do it? Solution: Please add the below property in your report and then do the export in CSV to achieve the desired results <property name="net.sf.jasperreports.export.csv.field.enclosure" value=""/> The csvReport.jrxml attached can be referenced which uses the above property and the report can be run using the Sample DB data adapter in Studio. ________________________________________________________________________________________________________________________ Ref. Case #02227980 csvReport.jrxml

Problem: Creating an Ad Hoc filter using a SQL Server datetime field includes results for two days, today and tomorrow, even when we provide a relative date "DAY" as the filter value. The same works fine with the SQL Server date field instead of the datetime field. What could cause this issue? Cause: The datetime in SQL Server has an accuracy of 3.33ms (0.003 seconds) - therefore, the "highest" possible value for Feb 27, 2024, for example, would be 2024-02-27T23:59:59.997 - anything beyond that will be rounded up to the next day. Solution: The resulting Ad Hoc query when using the above SQL Server datetime field as a filter includes "table_name"."column_name" BETWEEN { TS '2024-02-27 00:00:00' } AND { TS '2024-02-27 23:59:59.999' } When we remove the .999 from the endpoint timestamp and run the query against the database it calculates correctly and the data showed in the database is for DAY instead of today and tomorrow. Unfortunately, this is a SQL Server limitation and a recommended work around would be to use a date data type field instead of the datetime data type field to get the correct results in the Ad Hoc View. Further read: https://www.sqlshack.com/sql-server-datetime-data-type-considerations-and-limitations/ ________________________________________________________________________________________________________________________ Ref. Case #02241584

Requirement: Since that the Webservice-Plugin (https://community.jaspersoft.com/files/file/37-web-service-data-source/) is no longer supported in Jaspersoft Studio 8.2.0, we are trying to get the same results with a JSON data adapter. For example, in this public web service URI, https://api.predic8.de/shop/v2/products/, we need to make the URI dynamic so that the endpoint (...v2/products/1, v2/products/2, v2/products/3) can be changed by an input using a report parameter, like: https://api.predic8.de/shop/v2/products/$P{Parameter} where $P{Parameter} should substitute to 1 or 2 or 3 using a report parameter. GET https://api.predic8.de/shop/v2/products/1 or GET https://api.predic8.de/shop/v2/products/2 or GET https://api.predic8.de/shop/v2/products/3 Is it possible to use a report parameter to override the URI in a JSON data adapter like above? Solution: We can define a parameter in the report whose value overrides the URI in the JSON data adapter. e.g. <parameter name="DataURI" class="java.lang.String" isForPrompting="false" evaluationTime="Early"> <property name="net.sf.jasperreports.http.data.url"/> <defaultValueExpression>"https://api.predic8.de/shop/v2/products/" + $P{Parameter}</defaultValueExpression> </parameter> Please see - https://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.http.data.url Attached are the Sample report.jrxml and the Sample adapter.xml which uses the above public web service URI to illustrate and obtain the desired results. ________________________________________________________________________________________________________________________ Ref. Case #02240412 Sample adapter.xml Sample report.jrxml

Problem: When performing a binary installation of JasperReports Server 9.0.0, we are getting the below error. Any idea on how we can resolve this error? This version of the Java Runtime only recognizes class file versions up to 52.0 Cause: Here, the Java (Java Amazon Corretto 17) used is not supported with this type of installation. Solution: Java Amazon Corretto 17 is only supported for cloud installations of JasperReports Server 9.0.0. Please refer our Platform Support guide for the supported versions of Java and kindly use the certified versions of the software for the server installation. https://community.jaspersoft.com/documentation/jasperreports-server/jasperreports%C2%AE-server-platform-support-guide-commercial-edition/v900/jaspersoft-platform-support-_-javavirtualmachinesjvm-commercial/ _________________________________________________________________________________________________________ Ref. Case #02241893

Problem: We have tried to upgrade our JasperReports Server version from 8.0.4 to 9.0.0 in our environment and the upgrade was successful, but we did not find the Oracle JDBC JAR and in the UI when we tried to connect through Oracle data source, we did not find the driver in the drop-down menu, it is showing as "NOT INSTALLED" for Oracle driver. Any suggestions on how to proceed further with this situation? Cause: Starting from JasperReports Server 9.0.0 Progress JDBC drivers have been removed from JasperReports Server. Solution: If you have any resources that use or depend on any of the Progress JDBC Drivers, then you must manually install native drivers. After installing new drivers, update the resources in JasperReports Server to use the new drivers. Kindly see our Release Notes for more details. https://community.jaspersoft.com/documentation/jasperreports-server/tibco-jasperreports-server-release-notes/v900/relnotesbody-_-functionality/ As JasperReports Server doesn't include JDBC drivers for the following commercial databases: Oracle, SQL Server, or DB2, you need to obtain one of the available JDBC drivers and copy it into the correct location, and then edit default_master.properties before running the upgrade steps. See section "Working With JDBC Drivers" from our Upgrade Guide for more information. https://community.jaspersoft.com/documentation/jasperreports-server/tibco-jasperreports-server-upgrade-guide/v900/jrs-upgrade-guide-_-jdbc-driver/ ________________________________________________________________________________________________________________________ Ref. Case #02242678

Problem: When we save an Ad Hoc Report from a View with filter having more than 10000 values, the type of filter is getting changed and after saving the Report from the View the filter is seen as input string text field instead of drop-down. Solution: This threshold is configured by the property `maxAvailableValues` in the applicationContext-semanticLayer.xml file (<jasperserver-pro>/WEB-INF/) under the bean `slConfig. By default, it is set as 10000. Please try to enter a higher value for this property, save the file and restart the server for the changes to reflect. _____________________________________________________________________________________________________________________________________________________________ Ref. Case #02170550

Problem: We have upgraded to JasperReports Server 8.1.1 and are seeing a different behavior when accessing reports with PDF output. In previous version of Jaspersoft, end user was able to open the report directly in the browser without downloading it but in the current version of JasperReports Server 8.1.1 we are not able to open the report directly in the browser rather it is being downloaded. This is seen with all web browsers (Edge, Chrome and FireFox). Is there a Jaspersoft setting that control this behavior? Cause: The change in behavior was made on purpose because of a security aspect and there are no plans to change this behavior. Solution: To open the PDF file in the browser, we need to pass suppressContentDisposition as true in the URL. By default it is false. File name: ReportExportModel.js (jasperserver-ui/ce/bi-report/src/bi/report/model/ReportExportModel.js) Method name: urlOutput Replace the below line of code return this.url() + '/' + this.get('id') + '/outputResource'; with return this.url() + '/' + this.get('id') + '/outputResource?suppressContentDisposition=true'; So, the below steps can be followed to achieve the requirement: 1. Download the required source file from the eDelivery website (for example, TIB_js-jrs_8.1.1_src) 2. Make the above suggested changes in the mentioned configuration file. 3. Since we are making JavaScript customizations, we will need to rebuild the scripts using the Webpack approach. For complete steps on customizing JavaScript source code, kindly refer to the section 5.2.3, "Customizing JavaScript Source Code" from our Ultimate Guide. https://docs.tibco.com/pub/js-jrs/8.1.0/doc/pdf/TIB_js-jrs_8.1.0_Ultimate-Guide.pdf?id=11 Kindly note that the change to the current behavior of downloading the file instead of opening in the browser was made on purpose because of a security aspect and we are not planning to change this behavior. To force the browser to open the PDF report, you can follow the above steps but it is not recommended from a security perspective. _____________________________________________________________________________________________________________________________________________________________ Ref. Case #02211031

Requirement: We want to change the default color chart palette for Ad Hoc charts as given in the below article but for JasperReports Server 8.1.1. https://community.jaspersoft.com/wiki/how-change-tibco-jasperreports-server-71x-ad-hoc-chart-color-palette We have made the changes in the defaultPalette.js file and have rebuilt the scripts using the Webpack approach but the changes do not seem to take effect. How can we achieve the same with 8.1.1 version? Solution: The below steps can be followed to achieve the requirement: 1. Download the required source file from the eDelivery website (for example, TIB_js-jrs_8.1.1_src) 2. Make the required changes in the pro/bi-adhoc/src/adhoc/components/visualizations/chart/GenericChartVisualization.tsx file, method getDefaultColorsArray. 3. Since we are making JavaScript customizations, we will need to rebuild the scripts using the Webpack approach. For complete steps on customizing JavaScript source code, kindly refer to the section 5.2.3, "Customizing JavaScript Source Code" from our Ultimate Guide. https://docs.tibco.com/pub/js-jrs/8.1.0/doc/pdf/TIB_js-jrs_8.1.0_Ultimate-Guide.pdf?id=7 _____________________________________________________________________________________________________________________________________________________________ Ref. Case #02203310

Problem: We have upgraded to JasperReports Server 7.9.x and are seeing a different behavior when accessing reports with PDF output. In previous version of Jaspersoft, end user was able to open the report directly in the browser without downloading it but in the current version of JasperReports Server 7.9.x we are not able to open the report directly in the browser rather it is being downloaded. This is seen with all web browsers (Edge, Chrome and FireFox). Is there a Jaspersoft setting that control this behavior? Cause: The change in behavior was made on purpose because of a security aspect and there are no plans to change this behavior. Solution: As mentioned in the cause, the change in behavior was made on purpose because of a security aspect and there are no plans to change this behavior. To force the browser to do download the following code was added to applicationContext-webapp.xml file: <bean p:method="GET" p:urlPattern="/fileview/fileview/.*" class="com.jaspersoft.jasperserver.war.httpheaders.HeadersRule"> <property name="headers"> <list> <bean class="org.apache.http.message.BasicHeader"> <constructor-arg value="Content-Disposition"/> <constructor-arg value="attachment"/> </bean> </list> </property> </bean> Changing "attachment" to "inline" will force the browser to open the content in the same window (not new tab) when Open option is selected (Open in new tab option is not available anymore). But this is not recommended from a security perspective. _____________________________________________________________________________________________________________________________________________________________ Ref. Case #02211031

Problem: While working with chart component's data labels formatter using the below code, the data labels are not getting center-aligned and are always left-aligned. The same seems to be working in the retired 7.1.x version. <span>'+this.point.name + '\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0' + this.point.y +'%</span> Cause: It is a Highcharts problem. For more details, please see the Solution section of this article. Solution: This alignment issue is a Highcharts problem. Works in 4.2.1 (used by JasperReports Server 7.1.x), see https://jsfiddle.net/7m0u9s6a/1/ . Does not work in 6.1.1 (used by JasperReports Server 8.0.x), see https://jsfiddle.net/7m0u9s6a/2/ . And it works again in 10.1.0 (used in JasperReports Server 8.2.0), see https://jsfiddle.net/7m0u9s6a/3/ . As it is a Highchart version issue, we recommend to upgrade to the current latest JasperReports Server version to resolve this issue. _____________________________________________________________________________________________________________________________________________________________ Ref. Case #02197146

Problem: We have noticed for some of our reports that the borders are missing in DOCX export and the same is rendered fine in the PDF format. Moreover, the behavior seems to be band-specific, as when we use the border in the Title band instead of the Background band, the borders are seen correctly in the .docx format as well. What could be the issue here? Cause: The cause for this can vary based on the report design. A probable cause for this could be overlapping elements when using the borders in the Background band. Solution: The DOCX exporter (and other exports such as Excel, CSV, etc) does not support overlapping elements. It is recommended to design the report such that the elements of the report are not overlapping. Additionally, instructions on overlapping elements and suggestions on how to design a report accordingly can be found at the below link: https://community.jaspersoft.com/wiki/making-html-xls-or-csv-friendly-reports _____________________________________________________________________________________________________________________________________________________________ Ref. Case #02198536

Requirement: Is there an option in the application to stop a report that takes more than certain amount of time to run, for example 10 seconds? Solution: This is possible by using the net.sf.jasperreports.governor.timeout property. It can be defined globally or at report-level. To define it globally you can add this property with the required timeout as the value in the jasperreports.properties file (<jasperserver-pro>/WEB-INF/classes/). Kindly note a server restart would be required for this change to take effect. And, for report-level you can define the same property in the report source. You can read more about this property at the below link. https://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.governor.timeout _____________________________________________________________________________________________________________________________________________________________ Ref. Case #02201518

Requirement: We are noticing the log file in one of our environments contains logs for the last 24 hours whereas other environments have log entries for days. Is there a configuration setting that controls the amount of data stored in the jasperserver.log file? Solution: The logging properties and settings that you can change and configure are in the log4j2.properties file under the WEB-INF folder. For example, the below configuration keeps the logs active for 30 days: appender.fileout.filePattern=${log4j:configParentLocation}/logs/jasperserver.%d{dd-MMM}.log.gzappender.fileout.policies.size.type = TimeBasedTriggeringPolicyappender.fileout.strategy.max = 30[/code] If you are modifying this file, make sure to back up your existing file and kindly note a server restart would be required to save the changes from this file. _____________________________________________________________________________________________________________________________________________________________ Ref. Case #02200452

Problem: We are noticing that there is a hyperlink in the banner that says 'Skip to main content area'. When this hyperlink is selected, nothing occurs. This is present on a new install of JasperReports Server 8.2.0. However, on our 8.0.3 version, there is no corresponding hyperlink. Any idea on why this might be occurring? Cause: This may occur when the default theme is not present as per vanilla 8.2.0 because in new version 8.2.0 Product branding is only "Jaspersoft" but in your screenshot it is showing as "TIBCO Jaspersoft" and also "Skip to main content area" which is getting shown on the UI is not something Jaspesoft provides with the product. Somehow your theme is getting some of the customization or is used from the previous version. Resolution: Attached is the default theme from an 8.2.0 instance , please follow below steps to import the same in your 8.2.0 instance. Go to view > Repository. Then, right-click on Themes and choose option "Upload a Theme". Now select the ZIP file attached to this article, give name and click upload. Now, new theme with the given name will be added under your Theme folder, right click on this and select "Set as Active Theme" . Sometimes due to browser cache, the new theme will not get reflected directly. To verify you will need to clear the browser cache or try in different browser or check the same under an incognito tab of Chrome. _____________________________________________________________________________________________________________________________________________________________ Ref. Case #02189463 support_default_theme.zip

Requirement: Specifying "is one of" in the Ad Hoc View filter will display a list of choices. By default this list has the "Available" tab selected, is there any way to make the default the "Selected" tab? Solution: We can achieve this by triggering the click event on the selected tab element. To implement this, we need to update the code in jasperserver-ui/ce/js-sdk/src/components/multiSelect/view/MultiSelect.js file. Existing code: _availableItemsTotalCountChange: function () { this._updateAvailableItemsCountLabel(); this.heightAutoAdjustment && this._handleHeight(); } Updated Code: _availableItemsTotalCountChange: function () { this._updateAvailableItemsCountLabel(); this.heightAutoAdjustment && this._handleHeight(); this.$el.find('.jr-mMultiselect-toggleSelected').trigger('click'); } So, the below steps can be followed to achieve the requirement: 1. Download the required source file from the eDelivery website (for example, TIB_js-jrs_8.0.2_src) 2. Make the above suggested changes in the mentioned configuration file. 3. Since we are making JavaScript customizations, we will need to rebuild the scripts using the Webpack approach. For complete steps on customizing JavaScript source code, kindly refer to the section 5.2.3, "Customizing JavaScript Source Code" from our Ultimate Guide. https://docs.tibco.com/pub/js-jrs/8.0.0/doc/pdf/TIB_js-jrs_8.0.0_Ultimate-Guide.pdf?id=11 Following the above steps should help in changing the default tab specified in the Multiple Choice List filter to "Selected". __________________________________________________________________________________________________________________________________________ Ref. Case #02174913

Problem: Recently (post-upgrade to 8.0.x) we have noticed that some of the line chart panes in a scheduled dashboard are missing the second half of data points in the subscription email PDF. When we run it manually and export it manually, we don’t see any issues. Cause: This may be due to the PDF being generated before the animation is complete for the line chart. Solution: Please try to turn off the animations using below two properties to see if it helps: plotOptions.series.animation: false plotOptions.line.animation: false If you are using a JRXML report, you can set these properties by editing the HTML5 chart > Chart Formatting > Show Advanced Properties, and then expand plotOption > series > animation and set this to false. Similarly, we need to do this for plotOptions.line.animation: false If you are using an Ad Hoc View these properties can be set under the Advanced section of the Format Visualization tab. Also read, Charts disappear when report is exported or emailed by scheduler: https://community.jaspersoft.com/wiki/charts-disappear-when-report-exported-or-emailed-scheduler _____________________________________________________________________________________________________________________________________________________________ Ref. Case #02169534

Requirement: Want to display custom function arguments for Ad Hoc View on the server. Below is a related Wiki article but it doesn't work as the file /jasperserver-pro/scripts/adhoc/calculatedFields/factory/codeExampleFactory.js doesn't exist anymore in version 8.0.x and 8.1.x, neither the optimized scripts. https://community.jaspersoft.com/wiki/how-display-ad-hoc-view-custom-function-arguments So how do we configure custom function arguments on JasperReports Server version 8.0.x and 8.1.x? Solution: To display Ad Hoc View custom function arguments, please follow below steps: 1. Download the source file of the required version from the eDelivery website. For version 8.1.1, we need to download the file TIB_js-jrs_8.1.1_src.zip from the eDelivery website. 2. The codeExampleFactory.js file is located at the path - TIB_js-jrs_8.1.1_srcJasperReports-Server-8.1.1-srcjasperserver-uiprojrs-ui-prosrcadhoccalculatedFieldsfactory. Edit this file to make the required changes and add your custom function argument. 3. Next, since we are customizing a JavaScript file, we need to rebuild the scripts using the newer Webpack approach introduced from version 8.0.0. For detailed steps on this, kindly refer to the section 5.2.3, "Customizing JavaScript Source Code" from our Ultimate Guide: https://docs.tibco.com/pub/js-jrs/8.1.0/doc/pdf/TIB_js-jrs_8.1.0_Ultimate-Guide.pdf?id=7 4. Once the scripts have been rebuild with our changes, we need to replace the scripts folder under our jasperserver-pro with this newly generated scripts as detailed in the documentation above for the changes to reflect. _____________________________________________________________________________________________________________________________________________________________ Ref. Case #02169589

Problem: We have started seeing a 405 - Method Not Allowed error when exporting HTML5 Charts from our server. This used to work fine before but randomly we have started seeing this issue. No configuration or report changes were made, how can we resolve this error? com.github.kklisura.cdt.services.exceptions.ChromeServiceException: Server responded with non-200 code: 405 - Method Not Allowed. Using unsafe HTTP verb GET to invoke /json/new. This action supports only PUT verb Solution: This is a known issue (JRL-1820) with the recent Chrome update and a patch is already delivered - hotfix_JRSPro8.0.3_cumulative_20230322_1422 - which resolves this issue. Please install the latest 8.0.3/8.1.1 hotfix to your installation by following the readme.txt file in the hotfix ZIP to resolve this error _____________________________________________________________________________________________________________________________________________________________ Ref. Case #02176804

Problem: When the label text is large the pie size is small and vice-versa. The labels seem to force the diameter of the pie and the rendering is not professional, would it be possible to force the pie diameter? Solution: You can control the chart layout with the below Highchart property: plotOptions.pie.size - the diameter of the pie relative to the plot area. Smaller diameter means more space for data labels. A consistent way to control the pie size is to set a percentage value, for example: <hc:chartProperty name="plotOptions.pie.size" value="65%"/>[/code] _____________________________________________________________________________________________________________________________________________________________ Ref. Case #02165604

Requirement: To append single quotes or any of the special characters to a field while exporting it to CSV format. Solution: We can use below 2 properties to achieve this requirement of having end quotes for the fields exported to CSV. Kindly note that these properties can only be set globally or at report level. For more details, below links can be reviewed: https://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.csv.field.enclosure net.sf.jasperreports.export.csv.field.enclosure net.sf.jasperreports.export.csv.force.field.enclosure A test JRXML report is attached for reference which can be run using the sample Foodmart database. _______________________________________________________________________________________________________________________________________ Ref. Case #02171469 csvsinglequote.jrxml