cancel
Showing results for 
Search instead for 
Did you mean: 
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
Exciting changes

Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Kudo Data Story carousel

Data Stories Gallery

Visit our Data Stories Gallery and give kudos to your favorite Data Stories.

Top Solution Authors