Home > IT Answers > Business Intelligence > How to Display Japanese character in Crystal Report 8.5
Kaushalp
50 pts.
 How to Display Japanese character in Crystal Report 8.5
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 proc 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
ASKED: January 3, 2011  11:14 AM
UPDATED: May 6, 2012  11:58 AM
RELATED QUESTIONS
Answer Wiki:
I really don't think you can do this. I tried goggleing this and I didn't find anything. Yanni from <a href="http://www.dsr-inc.com">DSR Inc.</a> HI Yanni, I also did the same search & couldn't find any solution, that's why i've put question over here.
Last Wiki Answer Submitted:  January 4, 2011  1:44 am  by  Robert2010   465 pts.
All Answer Wiki Contributors:  Robert2010   465 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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.

Darryn
 765 pts.
 

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

Kaushalp
 50 pts.
 

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.

Darryn
 765 pts.
 

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

Kaushalp
 50 pts.
 

Can someone please provide solution for this?

Regards

Kaushalp
 50 pts.
 

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….

DOTNETEXPERT
 10 pts.