Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
hugoberry
Responsive Resident
Responsive Resident

Euro sign missing while rendering to PDF

In apaginated report if it mentions the euro sign, the rendering works fine for all the formats (docx, xlsx, ..) except for the PDF.

In PDF format the euro sign renders as a questionmark '?'. I've tried numerous combinations: Fonts, sizes, calling either Chr(128) or ChrW(8364). Still getting no luck.

Here are my attempts.

Rendering in Chrome

eurowebmatrix.PNG

which renders in PDF as

europdfmatrix.PNG

I've also tried iterating over all of the unicode characters trying to spot the euro sign

here it is on the web

euroweb.PNG

and again missing in PDF

europdf.PNG

And I know that the character should be there judging by this source

http://www.fileformat.info/info/unicode/font/arial_unicode_ms/blockview.htm?block=currency_symbols

 

The problem started apearing after installing the latest Aug 2018 version of PBIRS

1 ACCEPTED SOLUTION
hugoberry
Responsive Resident
Responsive Resident

Found a fix. Although I believe that has to be working by default.

Include the following ovverride in RSReprtServer.config

 

<Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PDFRenderer,Microsoft.ReportingServices.ImageRendering">
	<Configuration>  
		<DeviceInfo>  
			<HumanReadablePDF>true</HumanReadablePDF>
		</DeviceInfo>  
	</Configuration>
</Extension>

 For @msft dev people, here is how to troubleshoot the underlying problem

https://blog.idrsolutions.com/2011/04/mystery-of-the-pdf-file-and-the-missing-euro-character/

an interesting historical bug in PDF rendering

View solution in original post

3 REPLIES 3
AlexD
New Member

Hi,

 

we are facing the same problems with paginated reports / PDF rendering and the euro sign. The "HumanReadablePDF" flag is not really an option.

 

@Microsoft:

 

Please fix this bug.

 

Thanks.

hugoberry
Responsive Resident
Responsive Resident

Found a fix. Although I believe that has to be working by default.

Include the following ovverride in RSReprtServer.config

 

<Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PDFRenderer,Microsoft.ReportingServices.ImageRendering">
	<Configuration>  
		<DeviceInfo>  
			<HumanReadablePDF>true</HumanReadablePDF>
		</DeviceInfo>  
	</Configuration>
</Extension>

 For @msft dev people, here is how to troubleshoot the underlying problem

https://blog.idrsolutions.com/2011/04/mystery-of-the-pdf-file-and-the-missing-euro-character/

an interesting historical bug in PDF rendering

The downside of enabeling the HumanReadablePDF flag is that the PDF files can become rather large.

In some cases a 2MB is rendered to a mighty 188MB. 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.