Arabic text doesn't render properly when export to PDF

[Former Member]

Hi

I am having problem with exporting Arabic text to pdf and it doesn't render properly. The whole content render properly expcet the white space; the funny charater has been replaced to white space.

Does any one having that problem?

Note: I have tested with using both Crystal Report Designer XI and Crystal Report 2008 which come out same result.

Thanks,

Yin

[Former Member · Accepted solution]

Hi Yin

Would suggest you to confirm one thing

-Fonts must be available on the platform where the PDF file is viewed, or substitute fonts will be displayed;

Regards

Asha

[Former Member · Accepted solution]

Asha,

Thank you for your reply.

I used arial font to generate pdf.

And the strange thing is the problem only occure in generating pdf. Export to excel, html looks fine.

Thanks,

Yin

Edited by: Yin Min Phyu on Oct 10, 2008 2:09 PM

[Former Member · Accepted solution]

I think what Asha meant was to get the fonts onto the pdf too. That should resolve the issue as it does not look like crystal. Well it seems it is to do with fonts in pdf.

What version of pdf and in what language are you using it?

Regards

J

[Former Member · Accepted solution]

The standard Arial font was properly embed to pdf.

I do think it is something to do with Crystal rendering to pdf because when I create the arabic text from excel file to PDF, it is come out all right. And I tried with SQL reporting service as well and it come out all right.

The pdf version I am using is Adobe Reader 8. If it is something to do with pdf, the same problem should occure while generating pdf from SQL Reporting service or Excel to PDF.

It is just really annoying that the text from chart come out all right. It only happening for the paragraph.

[Former Member · Accepted solution]

How are you writing paragraphs? is it in one single text object?

To be honest I am running out of options here because whatever I thought its none of those so I might have to find out somewhere else how to resolve your issue.

Regards

J

Just a thought did you use " " or '' in your code because " " means empty in crystal and '' means empty in sql both things take differently.

also could you please check if your report options has "convert other null values to default" is unchecked?

Regards

jehanzeb

Edited by: Jehanzeb Navid on Oct 10, 2008 3:11 PM

[Former Member · Accepted solution]

Just One single text object.

Sorry I was typing the formula. I used both " " and ChrW(32).

Thanks you for taking so much time to resolve the issue.

If I can't find solution, my last option is to generate as HTML report which I am not very keen.

Thanks,

Yin

Edited by: Yin Min Phyu on Oct 10, 2008 3:17 PM

[Former Member · Accepted solution]

Ok the character which is coming up onto the pdf can you replicate that into the formula? or is that character/symbol not even in your keyboard or character list?

[Former Member · Accepted solution]

It isn't even on the character list or on my keyboard. I couldn't find that charater in charater map either.

I sent you the chart i produced from crystal and you will find that charater hasn't show up on the graph.

[Former Member · Accepted solution]

Ok what if you create a single object (text) type only 2 words with space. Conver it into pdf and see if that comes up with the same // symbol

[Former Member · Accepted solution]

I did as your suggestion, single object text with two words and space betwen the words and the funny character is gone.

So any idea?

[Former Member · Accepted solution]

ok try this, type the whole paragraph but only one space between each word.

So it would be like this

Hello What is your name. Hello Hello Hello

Don't put more than one space and try it.

[Former Member · Accepted solution]

Sadly it is still showing up

[Former Member · Accepted solution]

Ok another way of doing this would be to create a formula and then type the whole paragraph there and place the formula into the report and see if that produces the same text spacing character.

[Former Member · Accepted solution]

Hi J,

No, it is doing the same thing.

Did I mention that on the crystal report preview, it looks fine.

If you don't mind, can you try this as well in your crystal report?

Thanks,

Yin

Edited by: Yin Min Phyu on Oct 10, 2008 4:12 PM

[Former Member · Accepted solution]

Mine works perfectly.

I just sent you an email with attachment.

I copied the text put into text object under Report footer of the new report and export into pdf.

CR - 2008

Adobe Acrobat 8 professional.

Regards

Jehanzeb

[Former Member · Accepted solution]

SP0 download it from here

[http://resources.businessobjects.com/support/additional_downloads/service_packs/crystal_reports_en.asp#CR2008]

Regards

J

[Former Member · Accepted solution]

Morning Yin,

Did you have any luck with the download? The link I sent you does not need to download using username and password.

Additionally I doubt if your company would know what your username and password is for SAP as you got to request SAP to get one.

here is the link to the registration page.

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/new_user_pass/infouser_request.htm]

Register yourself first and then you will receive the username and password for it.

Hope this helps

Regards

Jehanzeb

[Former Member · Accepted solution]

Morning Jehanzeb

Just finished installation for SP1 and right now my pc is so slow I can't even move the mouse pointer.

I will get back to you very soon.

[Former Member · Accepted solution]

hmm I wonder if SP1 will resolve the issue as I mentioned in my earlier post it did not work for me. Lets see if that works for you. I thought SP0 would do the trick.

Anyhow, I guess you need a faster pc. you just reminded me when I had a slower pc when I started the job, then I asked the company if they need reports published they need to buy a pc I told them to buy. In 2 days time the new shinny pc was on my desk )).

Will wait for your reply touch wood everything should be fine after this

Regards

Jehanzeb

[Former Member · Accepted solution]

Hi J,

I couldn't find SP0 from XI release 2. So I thought SP1 is the first ever SP for XI release 2.

After installing SP1 for XI 2, tried to generate the pdf and it is still the same.

So now I am downloading SP0 from 2008 version and figer cross....

Yin

[Former Member · Accepted solution]

Yes! Sorry I thought we were talking about Crystal Reports 2008 first. XIR2 has SP1 not SP0.

It is strange that you have not able to fix the issue eve installing the Service packs. If the SP0 for CR2008 does not resolve the issue, I would suggest to uninstall Crystal totally from your pc and reinstall using SP0. This might get rid of the old registry keys of CR 08 and might help you resolving the issue.

Regards

Jehanzeb

[Former Member · Accepted solution]

I have removed Crystal Report XI R2 and as well as Crystal Report 2008 from my pc.

I installed Crystal Report XI R1 and see whether it has the same problem or not. Surprisingly, the report come out all right.

Now I am reinstalling XI R2 right. Hopefully it will work.

Yin

[Former Member · Accepted solution]

There you go, it must be a glitch somewhere. Usually strange things appear in Crystal which no one can answer.

That is why it is called "Crystal". )

Regards

Jehanzeb

[Former Member · Accepted solution]

It is working perfectly now.

Thanks for everything.

Yin

[Former Member · Accepted solution]

Not a problemo!

))

Regards

Jehanzeb