Arabic Text in Crystal Report

Question

I am having issues in displaying Arabic in crystal report. I am pretty sure that the data stored in Oracle is okay because when I query the same data using SQL Developer or TOAD, it is fetching and displaying Arabic contents as well. However, when the same query is used in the Crystal report, it is converting Arabic text into some weird Characters like ãÎÊáÝ etc. However, when I type Arabic in Crystal report, it is fine. The only issue is when I retrieve Arabic data from the database in Crystal report and try to show it, it converts it into some weird characters.

I am using Crystal Report 2008 version 12.0 and I used the font of the field to be "Arial Unicode" but still of no use. I even tried changing the font setting from "right to left"; still no use.

Any suggestions?

Answer 1

Use font called (Arial Narrow) it will solve your problem because it use arabic encoding.

right click on the field >> Format object >> tab Paragraph option Text Interpretation and set it to be RTF Text

Answer 2

Use This Font In Crystal Reports Arabic Typesetting Its worked With Me and BTW when Print Report with any other Font Will print with correctly Chars That mean Arabic Doesn't work at displaying Only !