cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with Kmer character

filippo_menditto
Participant
0 Kudos

Hi,

I'm using Crystal Reports 2011.

I have some problems with Kmer character.

As you can see in attached file above some character there is a little "+" and is not part of a Kmer character.

Seems to be a problems of USP10.dll.

Have you some idea about that ?

Thanks

Filippo

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Yes, I also have the same problem with Khmer Unicode view on Crystal Report.

Khmer word display incorrectly on Crystal Report application and on app developed

in Visual Studio.

After Replace new version usp10.dll,

Khmer word display correct on Crystal Report application

but not in Crystal Report viewer in Visual Studio.

Is it crystal report bug ?

What should we do now to display correctly Khmer word in application dev in Visual Studio ?

Thanks

0 Kudos

CR will use both versions, copy the other usp10.dll into this folder and see if that works:

C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86

Don

Former Member
0 Kudos

Hi Don,

First of all, I would like to say thank you for your respond.

Let me describe the behavior of Khmer Unicode

on Crystal Report for Visual Studio:

1- Test with old version usp10.dll

   On Design time:

      Drop a text box on Page Header section of Crystal Report

      then start write Khmer word in side the text box.

      . Khmer word display(render) correctly in Text box while  I am typing.

        We can read Khmer word in edit mode (cursor still inside the box). OK

       

      . But when we lost focused from the Text box

         by click some where outside the Text box,

         Khmer word have changed and we cannot Read. KO

        

       . Double click the Text box again in Edit mode,

         Khmer word in side the text box is correct. OK

             

   On Run-time:

       . Khmer word that we input on design time

         display incorrect. KO

         .

2- Test with New version usp10.dll

    (Copy new version to replace in C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for  .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86)

   On Design time:

      Drop a text box on Page Header section of Crystal Report

      then start write Khmer word in side the text box.

      . Khmer word display(render) correctly in Text box while I am typing.

        We can read Khmer word in edit mode (cursor still inside the box). OK

       

      . When we lost focused from the Text box

         by click some where outside the Text box,

         Khmer word still display correctly. OK

        

           

    On Run-time:

       . Khmer word that we input on design time

         display incorrect. KO

In summary, Khmer word display incorrect on Crystal Report for Visual Studio.

Please let me know if you need some more information about this issue.

Regards

0 Kudos

CR has a specific dependency on 1.4, not sure how or why it works with 1.6.

Attach your report with saved data and I'll test it

Former Member
0 Kudos

Hi Don,

I have attached you 3 files

1-Test_Crystal_Report.txt, 2-Test_Visual_Studio.txt, Report1.txt

After download on your computer, please Rename extension file:

  1-Test_Crystal_Report.txt to 1-Test_Crystal_Report.pdf

  2-Test_Visual_Studio.txt to 2-Test_Visual_Studio.pdf

  Report1.txt to Report1.rpt

Files:

1-Test_Crystal_Report.pdf

  This file describe my test scenario in Crystal Report.

  You can see Font config in my computer.

  See how Khmer word is written.

  And many screen shot..

  You should read this file first.

2-Test_Visual_Studio.pdf

  This file describe my test scenario in MS Visual Studio.

Report1.rpt

  Crystal Report file that was created in test

  1-Test_Crystal_Report.pdf

  It simply content one text box with Khmer word.

Please let me know if you need more info.

Thanks

0 Kudos

Found the possible cause:

https://launchpad.support.sap.com/#/notes/2318533

If link does not work the search for the number.

I tried your report in CR for VS SP 17 and I do see the font so the font is mapped in the report but when exporting to PDF the characters show up as boxes.

Problem is the font is licensed by MS:

Khmer UI

Because it's a licensed font CR can't embed it into the PDF due to licensing rules.

We can't get around that, on my PC I get a font type: Encoding: Identity-H

Which I believe means I don't have the font, which I don't.

So we may have a bug but SP 17 allows me to see the character in the viewer but exporting still replaces the font with Ariel, because I do not have it installed.

I don't see any way around this, try using a free version of the font.

Open the PDF and click on File, Properties and the Font tab and look for where the font is embeded.

Don

Former Member
0 Kudos

Hi Don,

Thank you for your reply.

1/

According to your comment:

  "I tried your report in CR for VS SP 17 and I do see the font...

  ...SP 17 allows me to see the character in the viewer "

And screen shot attached,

It seem that Khmer word display (render) correctly on your computer.

But Id doesn't work for me.

I have download the latest Crystal Report for Visual Studio

version 13_0_17 file name CRforVS_13_0_17.exe. Install on my computer.

After install Crystal Report for Visual Studio,

then create a new Crystal report project.

Browse for "Report1.rpt" that I send you in previous comment.

Design time, Khmer word display incorrect (bad render). KO

At run time, Khmer word display incorrect (bad render). KO

Could you advise what is wrong,

Why Khmer word display incorrect (bad render)

on Crystal report Viewer for Visual Studio ?

   I attached you my detail Test scenario with screen shot

   in file "TEST Crystal Report for Visual Studio 13.txt"

   After download on your computer, please rename file extension to pdf

   "TEST Crystal Report for Visual Studio 13.pdf"

2/

I cannot connect to url

   https://launchpad.support.sap.com/#/notes/2318533

It said that:

   "Your user does not have access to the SAP ONE Support Launchpad"

How can i see the issue(bug/Ticket/Defect) number 2318533 ?

Where can i search for the number  2318533

Regards.

0 Kudos

Font is licensed by MS - see the link above. So CR will not embed the font into the DPF file. We do not have the rights to do so.

The likely reason I can see it is because at some point I had a KMar font or equivolent installed on my PC. When Fonts are installed or selected they can sometimes embed themselves into other fonts like Tahoma etc. So I can render in the viewer, but as I said, when exporting to PDF because KHmar is a licenced font CR will NOT embed the font.

Use a Khmar True Type font that is free to use and distribute.

Former Member
0 Kudos

Hi Don,

I think "Khmer UI" font is created my Microsoft

and should exist on your computer run on MS Windows OS.

That's why I choose font "Khmer UI" as example to format Khmer word in Report1.rpt

so that you can see Khmer word on your computer when open Report1.rpt.

Anyways, I test choose many Khmer unicode TrueType Font

like Khmer OS font that is free to use and distribute

to format Khmer word on crystal report.

But Khmer word still not render well

on Crystal report viewer for Visual Studio as you can see in

screen shot in the Test Case attach in files:

   . 1-Test_Crystal_Report.txt.zip

   . 2-Test_Visual_Studio.txt.zip

   . TEST Crystal Report for Visual Studio 13.txt.zip

     (download and rename file extension from txt to pdf)

in above comment.

Don, I just want to see a correct Khmer word on

Crystal Report Viewer for Visual Studio at runtime

and can print the report to printer.

I don't want to export the report to PDF file yet.

You said Khmer word render well

on Crystal report viewer for Visual Studio on your computer,

please tell me how.

What should I do what font name should i chose ...?

-----

One more qa, you have said about 2318533...?

I cannot connect to url

   https://launchpad.support.sap.com/#/notes/2318533

It said that:

   "Your user does not have access to the SAP ONE Support Launchpad"

How can i see the issue(bug/Ticket/Defect) number 2318533 ?

Where can i search for the number  2318533

Regards.

0 Kudos

KHMAR by MS is a licensed font so CR cannot embed it into a PDF.

Sorry, I thought that number was a KBA, it's a SAP Note which you do not have access to unless you can log into Service Market Place, requires a support contract.

I created a KBA -

2344732 - Khmar UI font in CR Designer shows some "+" characters when previewed


The issue has been tracked and escalated to DEV for a solution, currently it will not work for you.


Thanks again

Don

Former Member
0 Kudos

Hi Don,

That's means Khmer word display incorrect (bad render)

on Crystal Report Viewer for Visual Studio And on application SAP Crystal report

due to there is an issue (bug) in Crystal Report itself

(But not due to Khmer Unicode or font).

Thank you for raising the issue

  KBA - 2344732 - Khmar UI font in CR Designer shows some "+" characters when previewed

to Crystal Report Developer team so that they can find a solution

and then fix issue bad render Khmer word on Crystal Report.

In order to help the Crystal Report Developer understand more

about Khmer word writing & see incorrect render Khmer word on Crystal Report,

Could you please download my testing document files in previous comment:

  •    1-Test_Crystal_Report.txt.zip
  •    2-Test_Visual_Studio.txt.zip
  •    TEST Crystal Report for Visual Studio 13.txt.zip

  (Unzip and Rename file extension from .txt to .pdf)

And then attached those testing documents to KBA - 2344732.

I am looking forward to see this issue is fixed  in the next update "Support Pack 18".

May i keep ask you the status of KBA - 2344732.

Best regards

0 Kudos

Hi Crystal,

You can watch the download page, just click Follow and you'll be notified when I publish an update.

Also, this is the original Forum post reporting the issue -

The problem also is because the font is licensed we can't embed it into a PDF, all due to permissions.

I looked at your report in my test app and I see the correct character, but I have a khmar font installed. I can't export it to PDF though.

Do you see it in the attached report? Unzip and rename it to prova.rpt

Also, because I have a Khmar font installed I see the characters in my test app, I don't see them in CR Designer which is odd though, please confirm the attached report and try the font attached to the othger forum post.

Don

Former Member
0 Kudos

Hi Don,

I download your file "prova rpt.txt.zip" to my computer to get file "prova.rpt"

Then test it in Crystal Report for Visual Studio.

New Project > Crystal Reports Application > From an Existing Report

Browse for the crystal report file "prova.rpt"

At design time,

Khmer word display incorrect (bad render).

   But if we double click on the text box to edit,

   Khmer word display (render) correctly. We can read Khmer word in edit mode (cursor inside the text box).

Start Run the application.

At Run time,

Khmer word display incorrect (bad render) on Crystal Report Viewer.

Could you please check my Testing document with screen shot attached below.

Download file "Test Crystal Report for Visual Studio.txt.zip"

to your computer. Then unzip and rename file extension from

"txt" to "pdf" so that you can open my testing document in app Adobe Reader.

Don, I just want to see a correct Khmer word render well

on  Crystal Report Viewer for Visual Studio.

I don't want to export the report to PDF yet.

I've changed many Khmer TrueType font that is free to use

to format Khmer word written in Crystal Report text box.

But the result is the same, Khmer word display incorrect (not render well) on Crystal Report Viewer for Visual Studio.

Thanks

0 Kudos

As noted R&D can duplicate the issue, I don't need to test it again.

Don

0 Kudos

R&D finished looking into this issue and discovered it is a limitation of the usp10 dll we use.

I've updated the KBA with this info:

Resolution

Our Developers have looked into this limitation and discovered the cause is due to Khmar fonts were not supported in USP10.dll version 1.422.3790.1830.

This is the version CR uses in the Designer and our SDK runtime.

According to this info: https://en.wikipedia.org/wiki/Uniscribe

Khmar was not supported until version 1.460.3707.0.

This limitation is by design now, we have looked into using an updated version and currently due to compatibility issues we cannot upgrade our version or support the updated version, it can cause CR Designer to crash on export and possibly other issues when used.

There are plans to upgrade to a higher version but no date at this time.

Currently only option is to not use Khmar fonts.

Don

PS - I've asked the Owner of CR and SDK to make sure this update gets into the Wish list for CR and SDK.

Former Member
0 Kudos

Hi Don,

Now we know clearly the issue why Khmer word (Script)

not render well on Crystal Report.

Because Crystal Report use USP10.dll

very old version 1.422.3790.1830 that not support Khmer script

(released since year 2005) .

Khmer Script was supported by USP10.dll

from version 1.460.3707.0.

To resolve the issue render Khmer script on CR,

new version of file USP10.dll have to be integrated in Crystal Report.

Thank Don for asking the Owner of CR and SDK to update USP10.dll.

I wish this update is done soon soon.

If possible should be fixed in the next update "Support Pack 18".

------
In the meantime, to work with Khmer script on:

>> SAP Crystal Report application:

  Replace file usp10.dll old version with new version 1.626  Located in folder

  C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\

  OR we just delete file usp10.dll  from folder

  C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86

  Khmer word(script) render well at Design time and on Preview time.

>> Crystal Report for MS Visual Studio 2013

   Replace file usp10.dll old version with new version 1.626

   Located in folder

   C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86

  At Designe time:

      Khmer word render well on Crystat Report Designer

   But At Runtime (click icon Start to launch application developed in Visual Studio)

    Khmer word NOT render well on Crystal Report Viewer.

     Is there any temporary or work around solution to force

     Khmer word render well on CR Viewer at Run time ?

Regards

Mesa E.

0 Kudos

Hi  Mesa,

Unfortunately DEV tried also and found a lot of potential backward compatible formatting issues. Our Formatting Engine relies heavily on usp10.dll to calculate where the objects are located, font, spacing etc. and if we change versions it can effect the whole report when viewing, exporting and printing so it's going to potentially be a huge upgrade problem for us.

They do have it in scope to upgrade but due to the above issues it may take some time to update, it definitely will not in SP 18

An upgrade of this nature would require a Full Version upgrade of all CR/BOE Products and cannot be released in a patch. This is not just in CR for VS, it's going to affect SAP BOE Enterprise which will affect millions of users....

Microsoft altered the way version 1.4.6 was updated and it's not fully backward compatible which is why we have not updated....

So nothing more we can do at this time other than for you to use a different font.

Don

0 Kudos

Crystal uses version 1.4 of usp10.dll, make sure it's being loaded.

Help... About... More Info, you will likely see both 1.4 and 1.6 loaded.

What language are you using and which font?

Try using MS Arial Unicode font to see if it works.

Don

filippo_menditto
Participant
0 Kudos

Hi Don,

I can see CRW32.exe use both usp10.dll ver. 1.0626.6000.16386 and usp10.dll ver. 1.0422.3790.1830.

The font is Kmer becasue document have text in Engligh/Kmer. This is as example of text:

ថ្ងៃចេញវិក្ក័យប័ត្រ

If I copy this text in Microsoft Word the text is correct. In CR1:

- When I double click on text label to write text I see text correct

- When I exit from label text i see like image you can see in attach

Laguage use in runtime program is VB.net 2010

filippo_menditto
Participant
0 Kudos

An update: if i change usp10 1.0422.3790.1830 to 1.0626.6000.16386 I can see in crw32 the kmer string correct. But when I load report in viewer from my application still is not correct. Also, export to pdf make to crash CRW32.exe and my application also. The same export from Microst Word works fine

0 Kudos

Don't know, as I said CR as a specific dependency on 1.4 version. Why or how it load 1.6 at the same time I don't know...

App is likely crashing because it's not loading 1.4.

Don

filippo_menditto
Participant
0 Kudos

Yes Don,

in my test I have the same conclusion. But with 1.4 Khmer font are not rendered right.

I attach e simple report with only one text box and khmer text.

If you double click the text box to edit you can see the corret Khmer text. But when you leave edit mode you see a different text, the same you can see in preview.

Font is Khmer UI

0 Kudos

attach the report... I'll have a closer look at it.

filippo_menditto
Participant
0 Kudos

The sistem not allow to upload.rpt file

0 Kudos

Use Advanced Editor, and rename the rpt file to *.txt

filippo_menditto
Participant
0 Kudos

This is the simple report.

0 Kudos

Hi Flilippo,

Thank you.

Where did you get these fonts?

I found Khmar OS font and tried it and I see the + sign also but it's not the same as the Khmar UI font you are using. And CR must use True Type versions only.

On Windows 10 I can get them from MS but they cost money so they will be licensed and will be a problem

Are these licensed fonts? If not can you attach it the post also?

If they are then it's going to be a problem. We can't embed licensed fonts into PDF's due to licensing.

You may want to have a closer look at the font also, Microsoft release a patch that blocks some fonts due to security issues in them.

The problem with not using the one from MS is those Fonts sites usually have trojans embedded in them so I don't want to just pick any one of them....

Where did you get yours from?

Thanks

Don

filippo_menditto
Participant
0 Kudos

Hi Don, I don't remeber where i found Khmer UI because I made a lot of test.

But I have the same issue with Khmer OS font: right string in edit and bad string with + when you show. If you dobule click text edit field you cas see a correct string. Khmer OS are Truetype fonts. You mean that are not usable in CR becase are opentype Truetype ?

The same string in microsfot Word and Khmer OS fonts are show right.

filippo_menditto
Participant
0 Kudos

This is Khmer ui.Rename to .ttf

0 Kudos

Thanks for the font. I'm not sure of the source so not going to test with your font.

I tracked it under: Incident 276525 / 2016 / Khmar font not working

SAP Note - 2318533

Don

filippo_menditto
Participant
0 Kudos

This fonts are secure and are digitaly signed.

filippo_menditto
Participant
0 Kudos

Hi Don,

Ho can I follow the incident 276525 / 2016 / Khmar font not working (SAP Note - 2318533) ?

0 Kudos

Hi Filippo,

Unfortunately you can't, I logged it under an internal Incident number so only accessible by DEV and Support.

All I can suggest is you watch the KBA, it should be updated by the Developer when it's fixed.

If there are no issues it should be fixed in SP 18 due out in September....

Don

filippo_menditto
Participant
0 Kudos

Hi, Don

I can give you a workaround. If you replace usp10.dll 1.0422.3790.1830 with 1.471.4063.0 version in this two folders :

\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86

\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86

CRW32.exe and application using SDK show Khmer characters right.

Only preview with CrystalReportViewer are not correct.

Filippo

0 Kudos

Thanks for the info...

We do have a specific dependency on 1.420.... and should be loading that version in both of those locations.