Activity for Sirichoke Kunnavatsuwan
-
Sirichoke Kunnavatsuwan posted a comment on discussion ART Help
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.
-
How can I do a parameter validation? How can I hide save parameter section?
-
It's work now. But I must copy THSarabunNewExtension.jas (customs font) into Tomcat/lib instead of ARTHOME/lib.
-
I follow instruction via https://sourceforge.net/p/art/wiki/Tips/#using-custom-fonts-in-jasperreports and https://community.jaspersoft.com/wiki/custom-font-font-extension My version is ART 4.10 It display as aspect via Jaspersoft Studio but after deployed into art server I got the error as below: net.sf.jasperreports.engine.util.JRFontNotFoundException: Font "THSarabunNewExtension" is not available to the JVM. See the Javadoc for more details. at net.sf.jasperreports.engine.fonts.FontUtil.checkAwtFont(FontUtil.java:603)...
-
I follow instruction via https://sourceforge.net/p/art/wiki/Tips/#using-custom-fonts-in-jasperreports and https://community.jaspersoft.com/wiki/custom-font-font-extension It display as aspect via Jaspersoft Studio but after deployed into art server I got the error as below: net.sf.jasperreports.engine.util.JRFontNotFoundException: Font "THSarabunNewExtension" is not available to the JVM. See the Javadoc for more details. at net.sf.jasperreports.engine.fonts.FontUtil.checkAwtFont(FontUtil.java:603)...
-
Roger that.... Thanks very much....
-
Yes, given sample-jxls22.xlsx works with ART 4.10 Snapshot. But still no luck with ART 4.2, the error still persists as first post when I applied with given sample-jxls22.xlsx.
-
Sorry, see here both
-
Sorry, see here both
-
After corrected as your suggestion, but still no result display in excel output file.
-
After tested with art-4.10-snapshot.zip, no error shown as earlier but no result display in excel output file as attached pic.
-
We currently running ART 4.2, and reproduced this with Jxls Sample 2 but error still persists as earlier. Modified sample-jxls2.xlsx as pic attached
-
We currently running ART 4.2, and reproduced this with Jxls Sample 2 but error still persists as earlier. Modified sample-jxls2.xlsx as pic attached
-
I created report with sql as below:- SELECT oph.TRANSNO, oph.TRANSDATE, opd.DESCRIPTION, opd.B_CHG, job.INVNUMBER, COALESCE(smi.OPTSERVGRP2, 'NA') AS OPTSERVGRP2 FROM (OPTRANSHEAD oph LEFT OUTER JOIN OPTRANSDETAIL opd ON oph.TRANSNO = opd.TRANSNO LEFT OUTER JOIN SMITEM smi ON opd.ITEMCODE=smi.ITEMCODE) LEFT OUTER JOIN OPJOB job ON oph.JOBNO = job.JOBNO WHERE oph.STATUS <> 'Deleted' AND oph.TRANSGROUP=#transClass# AND oph.TRANSCLASS='Billing' AND oph.TRANSTYPE='Local' AND oph.DOCTYPE='Invoice' AND...
-
By default, ART output filename is start with report name and append with datetime. But If possible to have a value of parameter as part of filename. From attached pic, if report name is XXXXXX. Can the result output filename as possible one of these choice? 1. XXXXX PEX19040076.XML (Append to report name) 2. PEX19040076 XXXXX.XML (Prepend to report name) 3. PEX19040076.XML (Replace report name with value of parameter)
-
By default, ART output filename is start with report name and append with datetime. But If possible to have a value of parameter as part of filename. From attached pic, if report name is XXXXXX. Can the result output filename as possible one of these choice? XXXXX PEX19040076.XML (Append to report name) PEX19040076 XXXXX.XML (Prepend to report name) * PEX19040076.XML (Replace report name with value of parameter)
-
By default, ART output filename is start with report name and append with datetime. But If possible to have a value of parameter as part of filename. From attached pic, if report name is XXXXXX. Can the result output filename as possible one of these choice? XXXXX PEX19040076.XML (Append to report name) PEX19040076 XXXXX.XML (Prepend to report name) * PEX19040076.XML (Replace report name with value of parameter)
-
Dear sir, It's me again. As title said, can we use some parameter which input by user as part of result file output?
-
Well, It works great. For xml extension, it shown on web browser after finish (based on browser behavior). This help us a lot, our user can view/verify it on screen before save it again.
-
Cool. Thanks for that. I will try and let you know the result.
-
Everything is fine if I set quote to one single character or use the default. All are correct. Thanks for cool reporting server and best ever support.
-
I just tried to using csv report type from query that return single row and single column.
-
One more strange thing about this... if I set quote to " " (single space) The CSV result will add a double quote in every single space as attached pic BTW, thanks for your kindly support...;)
-
Yes, I understood about that. But with FreeMarker, there is no such a null character. And for more info, this report get result from stored procedure as output parameter. That does not query from database directly.... as below... DECLARE @return_value int, @data nvarchar(max) EXEC @return_value = [dbo].[sp_GETXML_CSL] @jobno = #jobNo#, @data = @data OUTPUT SELECT @data as N'Manifest' And stored proc... ALTER PROCEDURE [dbo].[sp_GETXML_CSL] @jobno nvarchar(15) ,@data nvarchar(max) OUTPUT AS BEGIN...
-
Nope. It does not show the strange null character.
-
Thanks for quicky reply.... Actually I created a report as CSV with options below:- "includeHeaders": false "quote": "" But there are null character on top and end of the file as attahced pic. Can we remove this?
-
Thanks for quicky reply.... Actually I created a report as CSV with options below:- "includeHeaders": false "quote": "" But there are null character on top and end of the file as attahced pic. Can we remove this?
-
Thanks for quicky reply.... Actually I created a report as CSV with options below:- "includeHeaders": false "quote": "" But there are null character on top and end of the file as attahced pic. Can we remove this?
-
Dear ART Team, We have a report which use FreeMarker template to render the result but this only will shown on browser. How to redirect FreeMarker Template output result to plain text file? Thanks.
-
Hi, I create a report which query db and return a result as plain xml. But there is no option to output as xml file then I select output as csv instead and rename the result file. Can we add more file's extension for XML output file? Thanks. Sirichoke K.
-
Thanks. It works like a charm....;)
-
Yes, short desc shown after run the report. But can the description show at the parameters page as instruction/detail? This should help the users to understand about the purpose of the report/parameters. Thanks.
-
As subject, we would like to show description or short description as instruction/detail while user run the report. Can this be?
-
Thanks. New features (Eg., ReportEngine, C3, ... ) implemented since 3.3 and later, then version 3.2 does not exists those samples of new features.
-
If we need to create a new live database, how can we migrate from demo database in a bulk (not added one by one as I moved from 2.5)?
-
I install v3.2 as a fresh installation and add insert each report from version 2.5 one by one.
-
First, original 3.2 db does not have INSERT INTO ART_QUERIES VALUES(0,139,'C3.js 5',. And after run the scripts, nothing append into ART_QUERIES table. Only ART_REPORT_TYPES have more rows appened.
-
Yes, current ArtRepositoryDB.script doesn't have.
-
Yes, we use it as only internal. If we need to create a new live database, can we migrate from demo database to live?
-
Reference from Fresh Installation of Art 3.10 Report ID : 119-139 Eg., ReportEngine Localized report name OrgChart
-
Report ID : 119-139 Eg., ReportEngine Localized report name OrgChart
-
Dear Art Team, I upgraded from ART 3.2 to 3.10 by following the upgrade instruction. I excuted every upgrade sql scripts from 3.2 to 3.10. But the new samples does not exists in Art Reporsitory DB. I try to transfer the new samples from newly install version 3.10 via export to sql scripts. Can you suggest me about the essential tables for this? Regards, Sirichoke K.
-
First FWP LOV Business Group does not have any parameter. Then, I added fwpDS parameter into FWP LOV Business Group. It works. Thanks you very much.
-
Yes, it does.
-
I have 2 Lov Reports:- 1. FWP Lov Datasource which is LOV Static to provide as data source (database for each company) 2. FWP Lov Business Group which is LOV Dynamic to provide list of business groups (use Dynamic Datasouce) And report parameters as I run the report, do a change the first parameter (Company) which is datasource parameter. But the businessGroup (4th parameter) does not refresh. Please help. Thanks.
-
;)
-
After I followed your suggestion, it works now. Thank you very much.
-
I'm still using ART 3.2, can this be applied?
-
Dear sir, I created a report with JasperReport Art Query with using Multiple sheet feature. http://refermycode.com/export-the-multisheet-excel-file-by-using-jasper/ It works fine when running report with Jasper Studio, it can split data into multiple sheet. But then I upload to ART and run, all data shown in only one sheet. Doen anyone has experience with this? please help. Thanks in advance.
-
After looking into the code, you suggested. I 'm done with ${prmCompany.lovValues.get(prmCompany.value)}.
-
Thanks, it is very hard for me. I do not know java too much. BTW, ART is the best reporting tool. Thanks again.
-
Thank you very much....it works;) And can it display only display text? At first I follow sample-jxls9 it shows the label of parameter ('Company') instead of display text of selected parameter ('Profreight Ex.....').
-
According to the attached pic, what is function/property to show the display text of value in LOV. Thanks.
-
According to the attached pic, what is function/property to show the text of value in LOV. Thanks.
-
I tried with param.value/param.name and param.text. But all are not work, report return blank. Please help.
1