none
Is there a font hierarchy in SQL Server Reporting Services? RRS feed

  • Question

  • In our .rdl reports the `Arial MS Unicode` font is used. It's not installed with Windows Server 2019 anymore, as Microsoft stop paying for [it][1]:

    > When Microsoft included Arial Unicode MS with earlier versions of
    > Office, Microsoft paid a licensing fee to The Monotype Corporation,
    > which is the copyright holder for the font. Someone at Microsoft
    > decided it was no longer worthwhile to continue paying that fee, so it
    > was removed from the Office package.

    The license [cost][2] is pretty high for a single server with few cores - more then 7 000 $ per year.

    So, we decided to use as alternative a new font family - [Google Noto Fonts][4] - it's free and support more characters then `Arial MS Unicode`.

    The issue is that the fonts for different languages comes in different files and the files are of different types and cannot be unified. Also, as I am understanding there is no need to unify these files as in `PDF` the font is embedded and can increase dramatically the file size.

    So, my idea is to install all of the fonts on the machine and let the SQL Server Reporting Services to embedded only the needed ones. So, by default all text with have font `Nato Sans`. 

    The issue is when a text cannot be visualized by `Nato Sans`, for example some `Punjabi`: 

        ਤੇਜ਼ ਭੂਰੇ ਲੂੰਬੜ ਆਲਸੀ ਕੁੱਤੇ ਨੂੰ ਛੱਡ ਦਿੰਦਾ ਹੈ 

    instead `Nato Sans Gurmukhi`, different font is used - `Raavi`. 

    I am wondering is there any setting controlling how fonts are selected in case the current one is not installed on the machine or not able to visualize the corresponding text?

    The general idea is to install all `Nato` fonts and tell the reporting services to use them - in this way, all the reports will have fonts from the same family and the fonts will be embedded only when needed. 

    Note, the issue is generally in PDF files only, because in Excel or Word documents, there is no font embedding and the program is looking for fonts from the client machine.



      [1]: https://answers.microsoft.com/en-us/office/forum/office_365hp-word/arial-unicode-ms-font-missing/3d389ec7-dfaa-4002-adfd-5b1491cea8a1/
      [2]: https://www.fonts.com/font/monotype/arial-unicode
      [3]: https://i.stack.imgur.com/7Erta.png
      [4]: https://www.google.com/get/noto/

    • Edited by gotqn Wednesday, February 12, 2020 4:51 PM
    Wednesday, February 12, 2020 4:45 PM

All replies

  • Hi Gotqn,

    I am afraid there isn't a way to tell SSRS to use one font family. We need to install the fonts and manually set for those text, i.g, for the not visualized character we may need to test and set suitable font for it.

    [SSRS] Install and use custom fonts

    Regards,

    Lukas


    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, February 13, 2020 8:17 AM
  • Hi Lukas,

    Thanks for the reply. The issue is I have installed several fonts. Let's say the following:

    • font A Latin    
    • font A Cyrillic 
    • font A Japan

    each of them part of one font family A. So, I want to have in SSRS:

         "Some random text" with font A Latin

    and everything will work OK except when the report is generated, let's say by a client from Japan. 

    So, in PDF, the SSRS knows (somehow) that the Japanese text won't be visualized with  `font A Latin` so it starts to try using other fonts - when it founds such font, it embedded it in the PDF file. The issue is it is not using `font A Japan` but some other `font`.

    I want to know what's the algorithm of choosing such and am I able to control it?

    Regards,
    gotqn



    Thursday, February 13, 2020 9:04 AM
  • Hi gotqn,

    There isn't much doc about how SSRS is automating to find the font. 

    I advise you to post this issue in this website:.  https://feedback.azure.com/forums/908035-sql-server  Your feedback enables Microsoft to offer the best software and deliver superior services.

    Regards,

    Lukas

     

    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Saturday, February 15, 2020 6:41 AM
  • HI Lukas,

    I will try - https://feedback.azure.com/forums/908035-sql-server/suggestions/39735688-ssrs-font-hierarchy, but the feedback is typically slow and implementation of new features is quite slow :D ... 

    Regards,
    gotqn

    Tuesday, February 18, 2020 12:28 PM