Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Rendering a Report containing JPEG or PNG to PDF Expand / Collapse
Author
Message
Posted Tuesday, April 24, 2012 6:02 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, September 29, 2014 9:06 AM
Points: 477, Visits: 278
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



Post #1289463
Posted Wednesday, May 9, 2012 9:35 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, September 25, 2014 8:48 AM
Points: 1,293, Visits: 1,560
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
Post #1297205
Posted Tuesday, July 3, 2012 9:40 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: 2 days ago @ 4:10 PM
Points: 653, Visits: 3,881
>>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.
Post #1324461
Posted Sunday, December 22, 2013 8:00 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 3:51 AM
Points: 10, 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
Post #1525398
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse