Skip to Content
avatar image
Former Member

Crystal Reports: Missing UTF8 characters experienced during PDF Export

Hi,

      I've been troubleshooting this problem for a few days by now. And now it seems I've rounded up the problem to be due to PDF export. I have some middle english characters that are in the UTF-8 character set. For eg, Middle English yogh character -> ȝ. However, for some very strange reasons, I'm not seeing them turn up in my database fields in Crystal Report. But when I physically copied them into say a text object, then they look ok.

      

Here's what was displayed:

     

Notice the 2 circled text. They are the same middle english character but the latter one is from a database field and the header is where I copied the text into. I'm using the same font for both the header text and the details text. Arial Unicode MS and it is confirmed that the font supports the UTF-8 character in question.

I also double checked my object having that field, it is correctly set when I viewed via debugging mode. Also I have no trouble exporting the same report to Excel or Word. The character comes up right in both document format.

Thanks. Any help is greatly appreciated!!! 😊

Oh yeah, here's the code snippet I'm using for the export:

fileName is just a string value. Nothing fanciful here in case you're wondering...

 

_report.ExportToDisk(ExportFormatType.PortableDocFormat, fileName);

print.gif (6.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 25, 2012 at 05:35 PM

    Hello Cheryl

    What version of CR are you using?

    And what is the database and connection method used?

    Does the report work as expected inteh CR designer?

    Is the issue exclusively present on export to PDF, or do you see the same issue in the CR viewer for .NET, export to xls, etc.?

    Is this a web or a win app?

    - Ludek

    Follow us on Twitter

    Got Enhancement ideas? Try the SAP Idea Place

    Share Your Knowledge in SCN Topic Spaces

      

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Don Williams

      Hi Don,

           A big thank you for your reply. At least you help us unravel the mystery of why it works when we copy it simply as text. I did try searching for the character inside character map and you're right that Arial Unicode MS doesn't seem to have it.

           I thought using Arial Unicode MS in Word and HTML was enough to sorta proved that the character is included in this font.

          In any case, I think the best bet for us would be to stick to Arial Unicode MS font since it comes free and I doubt any business plan reports would really include Middle english characters. Let's really hope not! 😊

           Thanks!

      Cheers,

      Cheryl