Page 1 of 1

JasperReport Template doesn't show Persian characters

Posted: Mon Feb 04, 2019 8:53 am
by mamad
Hi,
i wrote an SQL based Jasperreport template using IReport tools which retrieve some fields from database. Some record inside database are in Persian language (Persian is RTL).Problem is that when i execute the query inside openkm, nothing shows(just some blank space) in the corresponding records to the Persian language terms while these fields shows in the Preview tab of IReport.
You can see it in the attached image.

Imag1 - Preview Tab of IReport tool :
1 (1).png
Image2 - Execution of report inside openkm :
2.png

Re: JasperReport Template doesn't show Persian characters

Posted: Thu Feb 07, 2019 7:01 pm
by jllort
Do you have the font what are using in the report installed into the openkm server? Take a look into the log of the server. Another problem might be the text is greater than the square space, sometimes is the space is not enought the ireport does not shown anything in the field.

I suggest take a look into the catalina.log file when you are executing the report, looking for some error or warning.

Re: JasperReport Template doesn't show Persian characters

Posted: Tue Feb 12, 2019 6:03 am
by mamad
thanks for your reply
I use the default fonts of IReport for this fields (Arial,SansSerif,Serif,..) but problem still remains
also check the square space and thats OK too
And About the log file :
I check log files inside tomcat-8.5.24/logs folder but no new log file generated when i executed report(i delete all logs before execution).
I think this problem does not relates to the font because i use one of the default fonts and the result is ok inside preview tab of IReport.

Re: JasperReport Template doesn't show Persian characters

Posted: Wed Feb 13, 2019 7:38 pm
by jllort
Must be sure you have in the server these fonts installed, anyway when fonts are missing the report is not executed and raised an error about the missing font.

I suspect you have another kind of error, can you try with another format of the report like CSV, sure there will be shown the real data created.
You are making SQL report.
What is the report charset? I think should be UTF-8