topic Re: Export a SSRS report to PDF - specific font lost in Report Server

Export a SSRS report to PDF - specific font lost

Anonymous — Fri, 18 Feb 2022 16:13:17 GMT

Hello the community,

We are now using a specific font in our SSRS reports.

However, on the PBIReportServer when we extract the report to PDF : the specific font is lost and replaced by Arial.

Of course, the font has been imported on the PBIReportServer server.

When we extract to Word this is fine.

This is really specific to PDF.

Do you know what could be missing ?

Thank you and best regards

Robin

Re: Export a SSRS report to PDF - specific font lost

Anonymous — Mon, 21 Feb 2022 07:05:59 GMT

Hi Anonymous ,

Fonts are embedded in the PDF file when the following conditions apply:

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.

Note：If the fonts used are the ones in the PDF specification that are commonly known as standard type 1 fonts or the base fourteen fonts, then fonts are not embedded for ANSI content.

For more information，you can refer to Export a paginated report to a PDF File

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Re: Export a SSRS report to PDF - specific font lost

Anonymous — Mon, 21 Feb 2022 13:26:55 GMT

Hello

Thank you for your fast reply.

I checked the parameters that you mentioned :

The font embeddability is not set to EMBED_NOEMBEDDING, but Installable
The font Type is true type

In the SSRS report all my items (titles, boards) are visible of course with the hidden setting at False :

Did I missed something in your explanation?

Thank again

Kind regards

Robin

Re: Export a SSRS report to PDF - specific font lost

Anonymous — Wed, 23 Feb 2022 05:54:37 GMT

Hi Anonymous ,

Did you restart the report server after installing the fonts? This step is required.

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Re: Export a SSRS report to PDF - specific font lost

Anonymous — Wed, 23 Feb 2022 16:28:46 GMT

Hi Anonymous

Yes I restarted the ReportServer service, and the server that hosts the ReportServer, and the result is still the same 😞 The font is still converted into MS Sans serif and Segoe.

An insight : the special font kept when extracting in Word from the report server.

Does that help to find what is wrong?

Thanks again

Robin

Re: Export a SSRS report to PDF - specific font lost

Anonymous — Wed, 02 Mar 2022 15:09:42 GMT

Hi @v-caitlyn-mstf

Yes I restarted the ReportServer service, and the server that hosts the ReportServer, and the result is still the same. The font is still converted into MS Sans serif and Segoe.

An insight : the special font kept when extracting in Word from the report server.

Does that help to find what is wrong?

Thanks again

Robin

Re: Export a SSRS report to PDF - specific font lost

Lorenzo95959595 — Tue, 09 May 2023 14:31:08 GMT

I´m having the same problem right now, did you find something?

Re: Export a SSRS report to PDF - specific font lost

Lorenzo95959595 — Tue, 09 May 2023 14:31:43 GMT

You find something?

Re: Export a SSRS report to PDF - specific font lost

Anonymous — Tue, 09 May 2023 14:59:57 GMT

Hi ! unfortunately no 😞

the solution proposed by ms was not enough. so i'm still not able to use additionnal font.

If you have some hints i am interested!

Re: Export a SSRS report to PDF - specific font lost

Anonymous — Thu, 13 Jul 2023 07:14:00 GMT

Hello, Try this please:
on the report server > right click on font file > Install for all users > restart reporting service.