pdfpentahopentaho-report-designer

Pentaho Report Designer PDF export is not showing the Japanese characters


I have created a report using Pentaho Report Designer 3.9.1 and it contains Japanese characters. When I try to export the report into PDF, I am not getting the Japanese characters in PDF. Instead of Japanese characters it's showing as empty in PDF.

When I try to export into Excel, Japanese characters are displaying.


Solution

  • It is known that built-in fonts of the JDK are mapped to built-in fonts ( SANS-SERIF, SERIF OR ANY OTHER BUILT-IN FONT) of the PDF standard and that these fonts do not support anything other than western-european languages.

    These fonts are not defined to include any Japanese characters as Japanese is not a western european language. If you use a font that does not include Japanese characters, you cannot expect it to display these characters.

    Configuration that is needed is in PRD.

    The reason behing the japanese font working with PDF because, if you are using a metadata as the datasource, the metadata fonts for that field will be having a default font set one say example "Arial-10". You will have to edit the font there or you will have to manually override it in the report designer by setting the "data-format and the style-format" to false.

    To get the result in BAServer:

    \biserver-ee\tomcat\webapps\pentaho\WEB-INF\classes\classic-engine.properties

    org.pentaho.reporting.engine.classic.core.modules.output.pageable.pdf.Encoding=UTF-8 org.pentaho.reporting.engine.classic.core.modules.output.pageable.pdf.EmbedFont‌​s=true

    Update : As per Rajasekaran M, he had to use the font SimHei in PRD and add simhei.ttf to fonts, inorder to work it in both PRD and BIServer.