Search code examples
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.

    • Click on File | Configuration
    • Click on 'output-pageable-pdf'
    • Set '~.EmbededFonts' to True
    • Set '~.Encoding' to UTF-8

    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:

    • Stop BA Server.
    • Browse to this file:

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

    • Change the following 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

    • Start the server.

    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.