cancel
Showing results for 
Search instead for 
Did you mean: 

Japanese characters are not displayed properly - Crystal Report XI

Former Member
0 Kudos

Hello,

We are upgrading reports from CR8 to CR11.

When I preview the CR8 report I can see the Japanese Characters (Coming from Database).

After saving the CR8 report as CR11 report, When I preview the report I cannot see the Japanese Character which I was able to see in CR8.

Why I am seeing unknown characters in CR11? When CR8 displays Japanese, then CR11 should display right?

Please help.

Thanks in advance.

Accepted Solutions (1)

Accepted Solutions (1)

ted_ueda
Active Contributor
0 Kudos

What character encoding are you using? Is it Unicode?

Sincerely,

Ted Ueda

Former Member
0 Kudos

Hi,

How to see that in Crystal Reports XI?

Is is possible to set the character set / encoding in Crystal Reports?

Both Crystal Reports 8 and 11 are mapped to the same database.

Database has the values in Unicode. (One sample value in db - 'æµ1ë±ïñô»ö¡ìsÄsÅÛî÷òÕÆnò¹ì┬')

Thanks.

Former Member
0 Kudos

Hi,

Which font do you have?

Try changing your font to Arial Unicode or to MS Gothic/MS Mincho.

Regards,

Shweta

ted_ueda
Active Contributor
0 Kudos

You set the output character encoding on the database, and not in Crystal.

If you're seeing random characters ''æµ1ë±ïñô»ö¡ìsÄsÅÛî÷òÕÆnò¹ì┬'" and not empty boxes, then the issue is with character encoding and not the font.

Sincerely,

Ted Ueda

ido_millet
Active Contributor
0 Kudos

Another suspect is the default printer driver. Make sure it supports Unicode.

Former Member
0 Kudos

Hi,

The report field uses MS Mincho font only.

My concern is, I am getting the Japanese character in CR 8 and not in CR 11. Same machine, Same DB and everything is same. The only difference is the version.

The same unicode is converted correctly in CR8 and not in CR11.

It is not working even when I set the CharacterSet to SJIS(Shift-Jis) in Database.

Any idea?

Thanks.

ido_millet
Active Contributor
0 Kudos

afaik, Unicode support started only with Cr 9. This means the text is probably not Unicode...

Former Member
0 Kudos

Ok, It may be some unknown characters.

But if it is displayed in CR8 means it should display in CR 11 also, right.

Still now, I dont have any solution for this

Please advice.

Thanks.

former_member183750
Active Contributor
0 Kudos

Are we talking, in the CR designer or in a .NET application here?

E.g.;, if it don't work in the CR desinger, it sure will not work in an app...

Ludek

ted_ueda
Active Contributor
0 Kudos

Did you set the database to translate output to Unicode - UTF-8?

Sincerely,

Ted Ueda

Former Member
0 Kudos

Hi Ludek,

I am talking about Crystal Reports software only, not in .Net. It is not working in the CR s/w itself.

Ted Ueda,

How to set that in the Database? Any Idea?

We are using Sybase.

Thanks.

former_member183750
Active Contributor
0 Kudos

Since this is in the designer, I'd recommend posting the query to the Crystal Reports Design forum:

I'd transfer this thread, but there is so much in here, all it will do is potentially cause confusion in the CR Design forum.

Ludek

Former Member
0 Kudos

Hi,

I already posted the same in CR Design forum. But no one replied to it

Thanks.

former_member183750
Active Contributor
0 Kudos

These are simply community forums - not technical support as such. You may, or may not get an answer. If you do need to contact technical support, you may want to consider obtaining a one case phone support contract from here;

http://store.businessobjects.com/store/bobjamer/DisplayProductByTypePage&parentCategoryID=&categoryI...

Ludek

Answers (1)

Answers (1)

0 Kudos

This issue is in CR designer. If it doesn't work in the Designer it won't work in code. Need to fix this iin CR first.