Rubik Font is SSRS exporting to PDF

kkran 831 Reputation points
2022-02-12T22:15:18.54+00:00

Hi - I am using visual studio 2013 and creating an SSRS report. I see the Rubik font is available and when exporting the report to PDF it's changing itself to a different font. Can you help me with how to solve this issue? 173805-rubik.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,796 questions
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,566 Reputation points
    2022-02-14T02:46:08.743+00:00

    Hi @kkran ,

    SSRS fully supports True Type Fonts (ttf) and has limited support for Open Type Fonts (otf). Essentially, any Font that can be instantiated by the .Net System.Drawing.Font (http://msdn.microsoft.com/en -us/library/system) class is supported by SSRS.

    Assuming you are installing custom fonts, you could prefer True Type Fonts (ttf).
    Next follow the steps below:

    1. Install fonts on your development maschine (where you design your reports with Visual Studio).
    2. Install the fonts on the server where SSRS Service is running likewise
    3. Restart report server to make it recognize the fonts.
    4. If Visual Studio was open, you need to close and reopen it to use the new fonts.

    Embed fonts in PDF files only if the following conditions are met:

    • Font embedding privileges are granted by the font author. Installed fonts include a property that indicates whether the font author intends to allow embedding a font in a document. If the property value is EMBED_NOEMBEDDING, the font is not embedded in the PDF file. For more information, see "TTGetEmbeddingType" on msdn.microsoft.com.
    • The Font is TrueType.
    • Fonts are referenced by visible items in a report. If a font is referenced by an item that has the Hidden property set to True, the font is not needed to display rendered data and will not be included in the file. Fonts are embedded only when they are needed to display the rendered report data.

    If all of these conditions are met for a font, the font is embedded in the PDF file. If one or more of these conditions is not met, the font is not embedded in the PDF file.
    For more information. please refer to: Exporting to a PDF File and Font Embedding.

    Note: This works only if the fonts are installed on the report server and then font embedding is enabled at the same time.

    Best Regards,
    Joy


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Constantin Klein 1 Reputation point
    2022-02-12T23:33:14.063+00:00

    You might want to check if the font is really installed on the report server, because in the docs for .pdf export it says: "Fonts that are used in the report must be installed on the report server."

    https://learn.microsoft.com/en-us/sql/reporting-services/report-builder/exporting-to-a-pdf-file-report-builder-and-ssrs

    0 comments No comments