Font renders correctly online, but not when exported to PDF or Excel

  • beth-447786

    SSC-Addicted

    Points: 458

    Hello,

    I'm having a problem with Wingdings/Wingdings 2 in SSRS reports exported to PDF or Excel (haven't tried other export formats). In my report I set the cell value and FontFamily from the dataset, i.e.;

    Value FontFamily

    * Wingdings

    P Wingdings 2

    and it renders correctly online (*/Wingdings = envelope, P/Wingdings 2 = check mark);

    font_online

    Exported to PDF;

    font_pdf

    Exported to Excel;

    font_excel

    Is there anything I can do to fix this? I did not have this problem under SSRS 2008 R2.

    thank you, beth

  • Mr. Brian Gale

    SSC-Insane

    Points: 23038

    Do you have those fonts installed on the server side?

    The fonts need to exist on both client (for rendering the report and viewing online) and on the server (for generating exportable formats).

  • beth-447786

    SSC-Addicted

    Points: 458

    Yes, the first image is the report rendered on the RS server, so that proves the fonts are installed there. The issue is exporting to PDF and Excel.

  • beth-447786

    SSC-Addicted

    Points: 458

    I wonder if the plug-ins (maybe the wrong term) used for the various available export formats, are what is to blame. It is odd that Wingdings printed properly to PDF, but not Wingdings 2, while neither font printed properly exported to Excel.

    I tried exporting to Word this morning; both fonts printed properly, and from that format I printed to PDF.

    Meanwhile, I've opened a ticket with our support folks and asked that they install both fonts if either/both are missing.

    Its odd that if they are not installed on the server, then the fonts installed on my machine are being used, but inconsistently.

  • beth-447786

    SSC-Addicted

    Points: 458

    Fonts now installed on the server, and were always on my laptop. PDF export now looks good, but Excel still doesn't recognize either font. Not sure if that is the fault of the plug-in used that enables export to excel, or something else. No bandwidth to chase that down, PDF was the format that was important.

  • Mr. Brian Gale

    SSC-Insane

    Points: 23038

    PDF working makes sense as that is rendered entirely server side.

    Excel though should work too.  If you do find some bandwidth to investigate, my guess here is that the font on your machine doesn't match up with the one on the server.  We had that problem with some label printers a few years back.  Label printers had 64 KB of storage and the font we wanted on there got upgraded in Windows 7 and the size grew larger than 64 KB.  Solution was to push the font from an XP machine short term and long term solution was to upgrade the printers.  They were ancient label printers.

    In your case, I am wondering if the server version of the font is different and incompatible with your local copy of the font.

  • beth-447786

    SSC-Addicted

    Points: 458

    I did not know that there were different versions of the "apparently" same font.

    thank you for your help.

  • Mr. Brian Gale

    SSC-Insane

    Points: 23038

    Gotta love how Windows does that... different OS versions can have different font files even though they have the same name.

    If you do try swapping fonts around, make sure to back things up first.  Don't want to find out that the server font is not compatible with your desktop/laptop and you have no way to roll back.  I've done dumb stuff like that before and then had to snoop around on other machines and VM's until I find the files I need on another system to get mine back up and working properly.

    Probably why Windows 7 needed you to be an admin to change fonts.  In 10 they changed that, but if a user changes fonts, it is for only that user.  So if you blow up your fonts, you can dump your profile and make a new one.  That being said, I've not tried that in Windows 10, so I still recommend making backups.

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply