How to Display Japanese character in Crystal Report 8.5

50 pts.
Tags:
Crystal Report 8.5
NVARCHAR
SQL Database
SQL Server 2005
SQL Server 2005 Database
Hi, I've some data stored in Japanese language in SQL Server 2005 database using nvarchar datatype. When I execute store procedure in SQL Server, it's showing japanese character properly in SQL server. However, when I'm trying to display data in crystal report 8.5, it's showing ????? character. I've tried to change font to 'Arial Unicode MS (Japanese)', MS Gothic, MS UI Gothic, MS Mincho (Japanese) as per the search result available in  google. But not had any luck. Can anyone please help me out for this?

Software/Hardware used:
Crystal Report 8.5, Sql server 2005, VB 6

Answer Wiki

Thanks. We'll let you know when a new response is added.

I really don’t think you can do this. I tried goggleing this and I didn’t find anything.

Yanni

HI Yanni,

I also did the same search & couldn’t find any solution, that’s why i’ve put question over here.

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Darryn
    Have you tried making changes in the "Regional and Language" options from the control panel? Try making changes to the "Advanced" tab as suggested in http://www.vbforums.com/showthread.php?t=355499 I googled "display japanese characters in crystal reports" and there were quite a few relevant discussions.
    765 pointsBadges:
    report
  • Kaushalp
    We're in UK region. We don't want to change regional settings to japanse as it may create some other problems for us. -Kaushal
    50 pointsBadges:
    report
  • Darryn
    Under the "Code page conversion tables" can you check if the "932 (ANSI/OEM Japanese Shift-JIS" tickbox is selected. If not, select it and try again. Something else you can try is to go into Crystal Reports designer, select File > Page Setup and check "No Printer (optimize for screen display)". (from SAP Knowledge Base) If that doesn't work, and you want to keep on looking, look for "double-byte characters" instead of just Japanese, as this widens the search, however, the problem was fixed in CR 9, so you might have to upgrade.
    765 pointsBadges:
    report
  • Kaushalp
    Hi Darryn, Where will i get “Code page conversion tables” option in CR 8.5? I've tried below otpion, select File > Page Setup and check “No Printer (optimize for screen display)”. it's not working. How would i set double byte characters? Fyi, I am using sql server 2005 & datatataype defined for the column which is stroing japanese characters is 'NVARCHAR'. Thanks Kaushal
    50 pointsBadges:
    report
  • Kaushalp
    Can someone please provide solution for this? Regards
    50 pointsBadges:
    report
  • DOTNETEXPERT
    This is possible. You have to do few thinggs and your report will start working. 1> Change the filed paragraph setting to RTF from none. 2> Select the required font e.g, if you are trying to display Arabic i selected Thoma(Arabic) 3> The above changes can be done in 8.5 but during you build the project upgrade th dll version to 10.0.3300.0 both web.config if mentioned and on any page if it using crystal viewer control. I just implemented this using VS 2003 & CR 8.5 & SQL Server 2005 and the requirement was like Dynamic header display changes. If its an arabic country then show arabic else english. Hope this helps....
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following