Word Renderer resolution settings for Chart
Hi there
I have a SSRS 2008 report that I'm rendering to word. This report contains a Chart.
I notice that the resolution of the chart creating is pretty poor and would like to increase this somewhat. I've looked and the Word Device Information Settings and can see nothing that might adjust this. (http://msdn.microsoft.com/en-us/library/cc281123.aspx)
Any thoughts and help greatly appreciated.
Regards
August 9th, 2010 2:03pm
Hi Rep Ronnie,
The renderer in Reporting Services 2005 resizes 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. In other words, your high DPI image may render larger than expected.
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. Even if the sizing being wrong, the image actually is rendering at a higher quality.
A necessary workaround is to size the image to the proper number of inches based on 96 DPI calculations. Then use Bitmap.SetResolution to set the images to at least 300 DPI. That may provide a higher quality image that is the proper number of pixels
to fit properly in the report.
For more information, please see:
Question14 "How to improve PDF quality of the report exported in Reporting Services 2005" in the following FAQs:
http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/48de91f9-1844-40c1-9614-5ead0b4b69a5
I think it the same to Word. Hope this helps.
Have a wonderful day :)
Challen Fu
Free Windows Admin Tool Kit Click here and download it now
August 11th, 2010 6:55am
Hi Ronnie,
We hit the same brick wall ourselves, using SSRS 2008 R2. Looks as though the WordRenderer is glued to 96dpi (screen resolution).
Although some of the other renderers can have their resolutions controlled by device information settings in the RSReportServer.config file (for example, with ImageRenderer and PDFRenderer you can specify DpiX and DpiY values) it appears that the WordRenderer
ignores these settings. Internally the WordRenderer calls upon the ImageRenderer to generate its inline images, but it seems to pass static 96x96dpi resolution parameters, so overriding ImageRender settings in the config file doesn't help.
Additionally the ImageRenderer always sets the image resolution metadata in the output file's headers to 96x96dpi, even though the image may have been rasterised at 150, 300 or 600dpi. This would seem to be a bug and something you may need to be aware of
if handling images yourself.
In our environment we set the PDF resolution to 300x300dpi and commented-out the WordRenderer in the RSReportServer.config file - essentially disabling export of Word documents altogether.
Hope this helps.
November 1st, 2010 3:10am