Rendering a Report containing JPEG or PNG to PDF

Question

Rendering a Report containing JPEG or PNG to PDF

cdun2

SSCertifiable

Points: 7893
More actions
April 24, 2012 at 6:02 pm

#260400

I have a report that contains embedded JPEG and PNG images. The images are sharp when the report is rendered in the Report Manager (Browser is IE 9). They look very fuzzy when the report is rendered to PDF.
Are there some general rules about how to work with images when the report render format will be PDF? Are there some resources out there on this.
Thank you for your help.
cdun2

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

gsc_dba SSCertifiable Points: 5407 More actions · Answer 1

cdun2 (4/24/2012)
I have a report that contains embedded JPEG and PNG images. The images are sharp when the report is rendered in the Report Manager (Browser is IE 9). They look very fuzzy when the report is rendered to PDF.
Are there some general rules about how to work with images when the report render format will be PDF? Are there some resources out there on this.
Thank you for your help.
cdun2

Here is a resource : http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/48de91f9-1844-40c1-9614-5ead0b4b69a5#P1Q14

#14 in the list relates to exporting images to PDF and can be summarised by

1) The PDF renderer in Reporting Services 2005 will size all images that it is given at 96 DPI no matter what DPI the image is when you pass it to the renderer. That means that a 300 DPI image or even a 600 DPI image will be sized in the PDF as if it is only 96 DPI. That means your high DPI image will render much larger than you expect.
So you might expect a 300 DPI image that is 6.5 inches wide to render properly at 1950 pixels. Yet, the PDF renderer will size it as it were 96 DPI which would make the image 20.3 inches long!
2) There is good news though. Despite sizing the images as if they were 96 DPI, the PDF renderer appears to render higher DPI images at a higher quality than 96 DPI. So despite the sizing being wrong, the image actually is rendering at a higher quality.
This means that you should size the image to the proper number of inches based on 96 DPI calculations. Then you can use Bitmap.SetResolution to set your images to at least 300 DPI. That should give you a higher quality image that is the proper number of pixels to fit properly in your report.

gsc_dba

Chrissy321 SSCoach Points: 15766 More actions · Answer 2

>>Then you can use Bitmap.SetResolution to set your images to at least 300 DPI.

Does anyone know how this is done? Is this a server side setting or is it report specific.

Thanks.

aframiller326 SSC-Addicted Points: 480 More actions · Answer 3

Again, a topic without any recommended solutions. Hope this link can be a feasible solution. If yes, please mark it. Thank you.

cdun2 (4/24/2012)

I have a report that contains embedded JPEG and PNG images. The images converting are sharp when the report is rendered in the Report Manager (Browser is IE 9). They look very fuzzy when the report is rendered to PDF conversion[/url].

Are there some general rules about how to work with images when the report render format will be PDF? Are there some resources out there on this.

Thank you for your help.

cdun2[/quote-0]

hipparchus2000 SSC Journeyman Points: 81 More actions · Answer 4

If you are using the WebAPI method to access Reporting Services, I found simply setting the DPI in the PDF section of the rsreportingservices.config didn't work, but this did:
In order to get better PDF rendering of Images, pass the Device Info like this:

apologies the editor here doesn't embed the text correctly, you'll find it in attached file:

lorenzo Newbie Points: 1 More actions · Answer 5

Hi EveryOne,

I begin in SSRS I have the same issue with my report containing .png image. I have to use .png to manage transparency because there is another background image. Following this post i already size the image to the proper number of inches based on 96 DPI calculations. then now can anyone help me how to do the use Bitmap.SetResolution to set the images to at least 300 DPI. your help will be very precious for me. thanks.