Anuj Dudhakawale

I've created a report with empty datasource. I've one parameter who has unicode "u092Au091Fu0928u093E u0909u091Au094Du091A u0928u094Du092Fu093Eu092Fu093Eu0932u092F" as default value. I've to use unicode only for HINDI charachters. When I preview the report, internal preview shows correct result, but pdf preview does not show correct rusult. I've attached my jrxml file. I've also seen iReports example of Unicode. Pdf must show unicode characters in Hindi languate.

I've created a report with empty datasource. I've one parameter who has unicode "u092Au091Fu0928u093E u0909u091Au094Du091A u0928u094Du092Fu093Eu092Fu093Eu0932u092F" as default value. I've to use Unicode only for HINDI charachters. When I preview the report, internal preview shows correct result, but pdf preview does not show correct rusult. I've attached my jrxml file. I've also seen iReports example of Unicode. Pdf must show Unicode characters in Hindi language.

Please give the information about output that you want from your query, and also give information about your table structure and columns.

1) Use table to show data of Users and phone. In dataset for table write your query Select * from MyTable 2) Write following query in main report Query Text. select count (Phone) as "Phone" from MyTable where Phone = 'iphone5' 3) Take your image at your page header, and check it's property " Print When Expression " In print when expression, write this statement $F{Phone}.intValue() != 0 Let me know whether it works or not.

During installation of font when you follow Tools > Options > Fonts > Install Fonts, you browse for font, after selecting font you want click on next, and in that window there is a check box for "Embed this font in the PDF document." check this box and press next button and complete that procudure. Also in report wherever you want to apply font, select that field and set it's font and in property set it property as 'Pdf Embedded'.

You didn't mesioned about what database you are using. If you are using Oracle 11g, then do following. Write following query in your dataset on which your table is depending. SELECT ID,NAME , LISTAGG(LINK, ', ') WITHIN GROUP (ORDER BY NULL) AS "LINKS" FROM emp GROUP BY ID, NAME After writing query, take all these fields into your table. After you take LINK textfield into your table set it's following properties. 1) Markup -> html After setting above property, preview your report.

Insted of using built in crosstab feature of iReport, you change the query so that it gives result like crosstab and use table to show the result of query. You use decode function in your query for getting crosstab result. It is possible to do that, I've done it in many reports, and it's performance is also very good.