Font in pdf-export
Hello! I have a problem regarding fonts in pdf rendering in SSRS 2008. I'm using Arial as font in my report, but when I open the pdf-document in Adobe Reader 9 and take a look in Properties/Fonts, Arial has turned into Helvetica and is no longer TrueType but Type 1. How can I get the pdf to show Arial instead of Helvetica?Example from Adobe Reader:when I use Arial:Helvetica Type: Type 1 Code: Ansi Current font: ArialMT Current font type: TrueTypewhen I use MicrosoftSansSerif instead:MicrosoftSansSerif Type: TrueType Code: Ansi Current font: MicrosoftSansSerif Current font type: TrueTypeI am using this version of SQL Server: Microsoft SQL Server Developer Edition, 10.0.1600.22 and OS: Microsoft Windows NT 6.0 (6001)When I look in windows/fonts on the server, I can see Arial as an "OpenType", but Helvetica is not even there...Any suggestions as to where I could look further? Or even better, a solution? :)
March 3rd, 2010 11:58am

SSRS does not include the font in PDFs... So the PDF will render using the closest font available to the PDF.This also occurs when you, for instance use a bar code font. It will render in SSRS, but export it into a pdf - no barcode.Managing Consultant - Mariner
Free Windows Admin Tool Kit Click here and download it now
March 3rd, 2010 11:58pm

Hi Karali,One of the changes we included in Cumulative Update #1 for SQL Server 2008 is automatic full font embedding and subsetting for Unicode characters in Reporting Services 2008 PDF rendering. With font embedding it does no longer matter what version of a font is installed on a client - the documents can be viewed the same way regardless of client operating systems, font versions, and client PDF viewer. Generating multi-lingual reports and using fonts such as MingLiU just got a little bit easier.From your description "I am using this version of SQL Server: Microsoft SQL Server Developer Edition, 10.0.1600.22", we can make sure you are running SQL Server Reporting Services in RTM version.So, I would suggest you updating the SQL Server Reporting Services 2008 to Service Package to fix the issue.Also, in some cases you need to open the font on the server (through the font control panel, so you can see the font preview) and then close the preview and reboot the server. Apparently this is sometimes needed to 'convince' the system to use the font. SQL Server Reporting Services Service Package 1(include Cumulative Update #1) is available at:http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19If you have any more questions, please feel free to ask.Thanks,Jin ChenJin Chen - MSFT
March 4th, 2010 12:43pm

Hi, Same problem for me, but I do have Service Pack 1... With MS Arial Unicode, it works fine (font is embedded). When I try to replace MS Arial Unicode with basic Arial, all I get is Helvetica, actual font : ArialMT. Arial font is on the server. Any idea ? Thanks in advance
Free Windows Admin Tool Kit Click here and download it now
March 9th, 2010 6:46pm

Hi!Thanks for your answer, I installed the SP and tried opening the font, but just as JeromeFRA below, the problem still remains...Any other suggestions?/Karin
March 10th, 2010 12:33pm

Hi, I have the same problem with SSRS 2008. All document is made with textboxes and standard Arial font. When i render it to PDF document get embedded Arial font and plus not embedded Helvetica font. Report language is default. Maybe i design report in wrong way and get this mystery attached default font. When reporting services render engine decide that need to attach this font? Maybe i can config something? It is problem when in other computers, without Helvetica font, somebody tries to print that document. In monitor that document looks okay but in printed page gets strange symbols. Any advice?
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2010 3:38pm

I have the same issue. I can create PDFs from Word that render fine, so I know it has to be the PDF renderer of Reporting Services that is not embedding the font.
June 1st, 2010 11:06pm

http://en.wikipedia.org/wiki/Portable_Document_Format#Standard_Type_1_Fonts There are fourteen typefaces that have a special significance to PDF documents: Times (v3) (in regular, italic, bold, and bold italic) Courier (in regular, oblique, bold and bold oblique) Helvetica (v3) (in regular, oblique, bold and bold oblique) Symbol Zapf Dingbats These fonts, sometimes referred to as the "base fourteen fonts" should always be present (actually present or a close substitute) and so need not be embedded in a PDF. PDF viewers must know about the metrics of these fonts. Other fonts may be substituted if they are not embedded in a PDF. In the Windows world the equivalent fonts for the first 3 are Times New Roman, Courier Newand Arial. Hence whenever one of these fonts is used the font name is mapped to their Adobe equivalent and it is not embedded. On a Windows machine a font like "Helvetica" is then mapped back to Arial, which is what Karali is seeing. Best regards, Andre
Free Windows Admin Tool Kit Click here and download it now
June 3rd, 2010 3:37am

Wayne, that's the problem I'm having. I'm using one TT Code 39 barcode font and cannot get the ssrs server to export the PDF using it. Did you find an answer, workaround to the issue? Thanksmrbello
October 30th, 2010 12:38pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics