How to break the 96dpi barrier when exporting reports containing SSRS Chart objects to Excel or Word ?

I'd like to export an SSRS 2012 report containing various standard/simple SSRS charts, to Excel/Word and PDF formats. Users want to open the Excel or Word versions and copy the chart images out to use in presentations etc. The problem is an old one : charts look ok in PDF but are really low-resolution in Word/Excel (96dpi I think), so look really grainy and are not of acceptable quality. I believe the problem is that the renderers for Excel/Word are hard coded to 96dpi.

After a lot of googling I haven't seen any practical solution, in any version of SSRS up to 2014. I am considering use of Nevron Charts for this, since a higher chart DPI can be chosen (and works). However, that means converting all the existing charts to use a 3rd party component which developers will have to learn, and buy and maintain the component etc , which is a lot of effort considering that I just want a higher dpi. Writing my own custom component or renderer is out of the question in this case.

I'm not getting why MS has never addressed this issue, especially since the Dundas chart components from which MS derived theirs did seem to have such a setting years ago (as does Nevron). So i ask this :

1. Does anyone have any experience or a real solution to this issue ?

2. Anyone know if this issue has been addressed in SSRS 2016 ? I cannot tell from CTP 2.2 whether its handled since there's no SSDT-BI tooling available yet anyway. (Mention of higher dpi seems to be restricted to display on high dpi screens).

3. Are there practical alternatives to Nevron which are still being actively developed ?

Any information or insights appreciated.

July 30th, 2015 10:54am

Hi Steve,

Thank you for your question. 

I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated. 

Thank you for your understanding and support.

Best regards,
Qiuyun Yu

If you have any feedback on our support, please click here.
Free Windows Admin Tool Kit Click here and download it now
July 31st, 2015 3:51am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics