Sinhala language unicode characters are swapped in sap crystal reports with visual studio 2012

[Former Member]

Hi, i'm new to crystal reports.I have stored data in Sinhala language as Unicode format into access database, when it displaying in Crystal Report characters are swapped, any solution? I tried with different Sinhalese fonts, but still have the problem

Thanks

[former_member11696 · Accepted solution]

We are now up to SP 20, just uninstall SP 5 and install SP 20 and test again.

https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads

First link to integrate into VS, do not install any other runtime on your DEV PC:

http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_13_0_20.exe

Don

[former_member11696]

What version of the SDK are you using?

What do you mean swapped?

Is the UNICODE font UTF-8 supported?

[Former Member]

Hi, I'm using visual studio 2012 with 4.5 .net framework, yes UNICODE font UTF-8 supported

This is how the characters are displaying in crystal reports, but originally character order should be in following order, following screenshot shows the data in access database. you will be identify the character order is wrong in crystal report. how can i fix this issue

thanks

[former_member11696]

OK, but you still did not say what CR SDK you are using?

[Former Member]

i'm using Crystal Reports for Visual Studio, how can i get sdk version

[former_member11696]

Look in Programs and features, it should say what version of CR for VS is installed.

[Former Member]

Yes, Product version is 13.0.5.891

[former_member11696]

Do a Repair install of CR for VS SP 21. Do not install the MSI redist package on your DEV PC and use the EXE to integrate into VS.

Remove ALL of the CR assemblies and then add ONLY the 3500 versions back in.

Open your form and VS should "fix" the viewer and add/update CR Viewer in the Toolbox.

Don

[Former Member]

what happend ??? is don william right??? is that worked ???

[former_member11696]

Since he was using Access to as the data source try ODBC and see if that helps.

Sorting is going to depend on the ASCII values of each character.

Also, that language is not officially supported by CR.

Don

[Former Member]

problem was fixed. but there is a another problem after i installed sp 21.here i attached the pic

[Former Member]

hi i have attached the screen shot