all groups > sql server reporting services > may 2007 >
You're in the

sql server reporting services

group:

Unicode export shows garbage in pdf


Unicode export shows garbage in pdf Manoj
5/30/2007 7:08:39 AM
sql server reporting services: Hi

I have SSRS 2005. I have translated all my reports to Chinese and
Japanese apart from the English version. When I export the Chinese or
Japanese reports in pdf formats it shows garbage characters. The other
formats (excel, tiff, html etc.) are working fine.

Is this an issue with pdf or do I require any SQL Server reporting
package to be installed to view the pdf reports? Any help will be
really appreciated.

Thanks and Regards,
Manoj
Re: Unicode export shows garbage in pdf Lisa Slater Nicholls
6/1/2007 8:08:46 AM
Manoj,

What fonts did you use in the report? Take a look at the PDFs' properties
(most viewers have a properties page where you can do this).

Here's why I ask: I'm not sure if the RS PDF export embeds fonts or not. If
not, then the PDF is doing a mapping of some sort to figure out which font
to match with the one designated in your report. There's a chance it is
mapping to a font that does not support the appropriate character set, or
does not support unicode.

Font mapping will be client-computer specific. It may also be "sensitive"
to regional settings on the client-computer -- I'm not sure about that -- so
what are your computer's regional settings?

Come to think of it regional settings on the *server* (rendering) computer
might *also* affect how fonts are embedded.

[quoted text, click to view]
Re: Unicode export shows garbage in pdf Andrew Hayes
7/23/2007 4:06:02 AM
SSRS 2005 does not embed fonts into the PDF. This means that the Acrobat
Reader determines which font substitution to use, and that depends on the
version of Reader you are using.

For example, a Japanese SSRS report containing a mix of English/Japanese
fonts ends up with some rather strange substitutions in Acrobat Reader 8.1.0 -

Helvetica-Bold, Type 1, Ansi is substituted for Arial-BoldMT TrueType.
MSGothic, TrueType, Ansi is substituted for MSGothic TrueType.
MSGothic, TrueType (CID), Identity-H is substituted for MSGothic TrueType.
MSGothic,Bold, TrueType, Ansi is substituted for MSGothic,Bold TrueType.
MSGothic,Bold, TrueType (CID), Identity-H is substituted for MSGothic,Bold
TrueType.
MSPGothic,Bold, TrueType, Ansi is substituted for MSPGothic,Bold TrueType.
MSPGothic,Bold, TrueType (CID), Identity-H is substituted for MSPGothic,Bold
TrueType.
MSUIGothic,Bold, TrueType, Ansi is substituted for MSUIGothic,Bold TrueType.
MSUIGothic,Bold, TrueType (CID), Identity-H is substituted for
MSUIGothic,Bold TrueType.

It still looks OK, but when the PDF file is viewed in Acrobat 6.0.0 it comes
out garbled. It looks fine in 6.0.1.
AddThis Social Bookmark Button