SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Rendering a Report containing JPEG or PNG to PDF


Rendering a Report containing JPEG or PNG to PDF

Author
Message
cdun2
cdun2
Say Hey Kid
Say Hey Kid (713 reputation)Say Hey Kid (713 reputation)Say Hey Kid (713 reputation)Say Hey Kid (713 reputation)Say Hey Kid (713 reputation)Say Hey Kid (713 reputation)Say Hey Kid (713 reputation)Say Hey Kid (713 reputation)

Group: General Forum Members
Points: 713 Visits: 291
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



gsc_dba
gsc_dba
SSCommitted
SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)SSCommitted (1.8K reputation)

Group: General Forum Members
Points: 1751 Visits: 2017
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.


_____________________________________________________________________________________
[font=Courier New]gsc_dba[/font]
Chrissy321
Chrissy321
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1232 Visits: 4698
>>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
aframiller326
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
Points: 36 Visits: 31
Again, a topic without any recommended solutions. Hope this link can be a feasible solution. If yes, please mark it. Thank you.


http://www.networksteve.com/enterprise/topic.php/How_the_image_resolution_of_the_PDF_can_be_configured_in_SSRS/?TopicId=38142&Posts=2



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.

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

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search