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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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