Sirichoke Kunnavatsuwan

Thanks but still out of luck.... I followed your advice but error occurred.... java.lang.SecurityException: Unexpected type: class art.reportparameter.ReportParameter, value = ReportParameter{reportParameterId=477} at art.utils.GroovySandbox.filter(GroovySandbox.java:155) at org.kohsuke.groovy.sandbox.GroovyValueFilter.filterReturnValue(GroovyValueFilter.java:26) at org.kohsuke.groovy.sandbox.GroovyValueFilter.onGetProperty(GroovyValueFilter.java:73) at org.kohsuke.groovy.sandbox.impl.Checker$6.call(Checker.java:288)...

I succeed with data, datetime, but have no luck with report paramerter. My point is trying to customize date parameter into my desired format. Can u suggest me the sample of this?

Dear all, I try to but no success with Date parameter. Eg. fileName: "Listing as of f[#execDate#|dd-MM-yyyy]f" The result will shown as "Listing as of f_2023-08-30-00-00-00|dd-MM-yyyy_f" Thanks Sirichoke K.

Thanks. Now I already upgraded to Tomcat 9. The error still shown as my first post .... net.sf.jasperreports.engine.util.JRFontNotFoundException: Font "THSarabunNewExtension" is not available to the JVM. See the Javadoc for more details. The root caused of problem was found in Tomcat log as below ( my report has QR Code ) 02-Jun-2022 08:59:55.986 SEVERE [http-nio-8080-exec-5] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [dispatcher] in context with path [/art]...

Thanks. Now I already upgraded to Tomcat 9. The error still shown as my first post .... net.sf.jasperreports.engine.util.JRFontNotFoundException: Font "THSarabunNewExtension" is not available to the JVM. See the Javadoc for more details. The root caused of problem was found in Tomcat log as below ( my report has QR Code ) 02-Jun-2022 08:59:55.986 SEVERE [http-nio-8080-exec-5] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [dispatcher] in context with path [/art]...

The problem raised again after I upgrade ART to the newest version (5.25) and Tomcat 8. (Last time I deployed on tomcat7)

Date parameter, this type, users always entered the wrong format. Or can we disable direct input, just only click from drop down.

Jxls output as your choice. You can decorate excel file as template. Hope this help.