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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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

Top Solution Authors