Arabic data from database inverted in Crystal Report

[Former Member]

Hi,

I have Arabic data in one of the columns in table & when i try to report that in crystal, the Arabic data are inverted, or jumbled i don't understand in what form it is since i don't know Arabic. Please help thanks in advance.

Lets say, for an example :

I have 3 database fields fld1, fld2 & fld3 coming from stored procedure. Now , the order should be in report as fld1 - fld 3 from right to left. Fl1,2,3 all are in Arabic , additionally fld 2 is integer. So when the report executes fld1 & fld 3 interchanges their positions.

Please help.

[Former Member]

Hi Venkat,

Thanks for your reply. The problem is not concerned about the printing. Lets give you a brief example:

I have a stored procedure which supplies 4 data field x1, x2, x3 and x4. Out of which x1 is an integer field while the rest are strings. Now I want to create a formatted letter where these fields are supposed to be dynamic. Now the order of these fields would be as follows:

<some sentence in Arabic> x2  x1 x3 <Some sentence in Arabic>

Now, as far as x1 is varchar there is no problem. But if x1 is an int the position of x2 and x3 gets swapped. So the letter looks like...

<some sentence in Arabic> x3  x1 x2 <Some sentence in Arabic>

One reason can be while the crystal report reads the fields in case of integer it cant read from R->L and that is why it reallocates the format.

One question - Can we install the Crystal Report in Arabic culture?

[venkateswaran_k]

Hi

Yes, I was referring to the same. When the numeric fields comes in between the texts, the result is jumbled.  Can you convert the X1 to alphanumeric when you actually putting in the place holder of your letter.

Regards,

Venkat

[venkateswaran_k]

Hi

Are you concatenating the field and printing it?

If so, then do not do that.

Print it separately.  If you concatenate the arabic and non arabic - then the resultant will be jumbled.

Regards,

Venkat