prparame

Hi Tino-Ferreira, Are you still encountering this issue? Could you please specify the repository database you're using? From the logs, it appears that the system is flagging that the file \js-jrs_9.0.0_bin\jasperreports-server-pro-9.0.0-bin\buildomatic\build_conf\default\webapp\WEB-INF/js.quartz.properties is inaccessible. Please verify whether the user running the buildomatic js-install command has the necessary permissions to access this folder. Please go through the Dr. Jaspersoft YouTube session on deploying a war installation : Please let me know if this fixes the issue.

Hi Yazil Santoyo, I am attaching a sample jrxml which will aggregate the sum of financial values in a separate column as shown below. I hope this will fix your issue. Else please share your sample jrxml here for more analysis. report_Vertical_total.jrxml

Hi Scene, This can be achieved by using the expression : DAYS($F{testdate},NOW( )) Please see the attached jrxml file and screenshot. DateIssue.jrxml

Hi dschafer, This issue appears to be linked to the roles and permissions assigned to your non-admin users. Are these non-admin users classified as external users? 1. Verify whether the reports can be executed by admin users. If they can, it confirms that there are no issues with the JRXML reports. 2. Determine if all non-admin users are encountering this problem or if only some are affected. Compare the roles of users who can run the reports with those experiencing the issues to identify any differences. 3. Is there an SSO mechanism (OIDC, SAML, Preauth, LDAP) in place that Jasperserver uses for user login? If so, please verify with the IDP to ensure that there are no issues with the roles assigned to non-admin users. When a user logs in through SSO, their roles are synchronized from the IDP to Jaspersoft. Please check the above points. If this doesn't solve the problem, please attach the full stack trace of the logs which will help us to analyze further. Thanks Prasanth

Hi Ahmed, Could you please share the jrxml file as well? Also, I would recommend to go through the below Dr. jaspersoft session.

Hi Nitish, Instead of '', can you please try with null and see if this makes a difference? Also, try the below format to skip the null condition check. ( D.inventoryRegistrationTime = $P{start_Time_From} OR $P{start_Time_From} IS NULL )

Hi DireConseq, You could download the Jaspersoft Studio and open the jrxml file. Using this, you can check/analyse the queries and input controls associated with a report/jrxml. Please see the below screenshot.

Hi Gosego, Could you please provide more details. Which version of Jaspersoft are you using? Are you referring to Jaspersoft Repository? Could you please share some screenshots where you face this issue?

Hi, Could you please share the sample jrxml file for this issue. From the error, the report seems to refer to a class file "object from file: C:...". Please check and see if any customizations are present in your Jaspersoft application and if that complies with an old version of Java. Also, please share your Jaspersoft log files(\WEB-INF\logs\jasperserver.log) for further analysis.

Hi, It seems that the error is happening while parsing the file " Caused by: org.jboss.as.server.deployment.DeploymentUnitProcessingException: JBAS011666: Could not parse file C:\wildfly-8.1.0.Final\domain\servers\server-one\tmp\vfs\temp\temp97584868c3133263\content-91a4ebf0859ad950\WEB-INF\applicationContext-jms.xml" I could see a similar issue in one of the community threads: https://community.jaspersoft.com/wiki/cannot-start-tibco-jasperreports-server-630-jboss-wildfly-parseerror-logs Please check the above thread and see if this resolves the issue.

Hi Andrew, Can you check the below steps and advise 1. Check the Jasper server logs and see if we get any errors in the log files. 2. navigate to manage --> Server settings --> Adhoc cache and see if the queries corresponding to the filter are getting executed or not. If there are any errors in the logfiles (Jasperserver logs --> WEB-INFlogs) or catalina.log, Please share the same Thanks Prasanth

Hi, You can use CSV or Excel data adapters to retrieve the data from a CSV or Excel file. You can use this to populate the data in reports. Please refer to the below documentation and see if this fits your requirements. https://community.jaspersoft.com/questions/802580/how-create-excel-data-source-jasperreports-server https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v640/using-csv-data-sources Keeping the data hardcoded in the Java code may not be a good idea as we have to redeploy the code every time we modify the employee details. If you are getting the employee details from a Rest API endpoint, you can use an AutoRest database connecter. Please see more details about auto rest in the below community page. https://community.jaspersoft.com/wiki/autonomous-rest-connector-tibco-jaspersoft-studio

Hi Jonas olsson, Jaspersoft supports Json Datasource or Autonomous REST connection which can invoke API calls and retrieve data in Json Format.: Please refer to the documentation: https://community.jaspersoft.com/wiki/autonomous-rest-connector-tibco-jaspersoft-studio Deployment Manage Repository: JasperReports Server has a built-in repository where you can store your report resources (JRXML files, images, translations, etc.). You can use the Jaspersoft WebUI Interface to login to the application and then manage the repository. Export and Import of Resources: We can try to export all the resources as a zip folder. Please refer to the old documentation(Please check the version of the old Jaspersoft and check the steps in jasperreports-server-administration-guide. Here I have given the document for JRS 5.5): https://community.jaspersoft.com/documentation/jasperreports-server-administration-guide/v550/import-and-export-through-command-line. You can try to export from the old Jaspersoft and then import the zip folder to the latest version of Jaspersoft. A sample export and import command : js-export --everything --output-zip EverythingExportTest.zip --include-attributes --keyalias deprecatedImportExportEncSecret & js-import --input-zip EverythingExportTest.zip --skip-themes --keyalias deprecatedImportExportEncSecret --update Now test the reports and see if there are any issues with the report execution. Since you mentioned that your existing Jaspersoft is very old, there are chances that minor modifications need to be done either on Jrxml reports or on the server configuration. Make sure you test all the different reports/flows before promoting the changes to Production.

Thanks for the confirmation. As mentioned in the comments, I could handle the apostrophe on JRS 804. The workaround "created a duplicate column where I have stripped out the apostrophe and used that to filter the report but not show it in the report" will also handle the above scenario.