on 05-11-2016 4:37 PM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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:
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
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.
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.
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.
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
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:
(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
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
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
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.
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.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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.
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
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
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.