I am using Crystal Reports 10. The reports are obtaining data from an Oracle 10G database. We have some data in Arabic. When I try to display the Arabic data it is showing as ?.
Any ideas on what I can do to display this correctly?
4
votes
4 Answers
4
votes
I've never used crystal reports and my oracle knowledge is limited, however I've done some work in Arabic. Things to look out for.
Does the Database have the arabic locale installed can it display right to left text.
Under windows check the languages settings and check that the option to include support for left to right writing systems is installed.
Check that your database is the international version and not one that only supports the latin character set. It may be that there is a problem converting between ASCII and Unicode.
Arabic Characters are not on the same ASCII code page as the Latin Character set your machine will be used to using, there might be a special version of crystal reports that supports arabic.
Check that the machine you are running crystal reports on has the arabic locale/fonts installed on it.
UPDATE
I've Had a quick look on the internet and you might want to look at this link
Here is a summary:
This issue can be solved when you create the reports without needing to write any extra code. I haven't tested this solution because I don't have any data to test it against.
First you want to make sure that you are using a UNICODE font which I'm sure you are probably already doing. Then to configure the "Right to Left" you can right click on any field and select "Format Text" or "Format Field". You should see a "Paragraph" tab. In there you can set the content to be "Left to Right" or "Right to Left". The button on the right allows you to make this setting conditional on a parameter value or something like that. I hope this helps.
0
votes
