hittle

You may have to write a query executer that extends the basic JdbcQueryExecuter functionality for the SQL query language. I remember in JRS 3.5.x we had implemented that but I am not sure if it is still necessary for the latest version of JRS since there seems to be better support for parameters containing a list of values (ie. the $X{} parameter replacement).

I have had an open ticket with Jaspersoft for some time regarding this issue. By default PDF exporting uses the Helvetica font (which does not have support for Identity-H). You need to use a font that supports Identity-H, such as Arial Unicode MS and then configure your report to use that font for PDF generation. Also note that a font can be embedded into a PDF so you will need to be aware of some potential licensing issues if you embed a font. If you do not embed the font then the consumer of the PDF must have that font on their system in order for the multi-byte characters to be rendered correctly. I would recommend looking at this documentation about font extensions. You will see that JasperReports Server has the "DejaVu" font bundled with it that can be used for PDF generation, unfortunately, that font also does not support multi-byte characters. With JRS 4.5 I was not successful in "installing" a new font using the font extension method that could be available for all reports at PDF generation time (similar to "DejaVu"). However, it is possible to provide a font extension as a resource to a report if you have iReport to generate the font extension.

JRS 5.0.1 was released on December 20, 2012 (at least for commercial license holders). You can likely get a trial version of the commercial edition here. It looks like the community edition did not receive the v5.0.1 update.