Thursday, August 23, 2012

SSRS SQL Server Reporting Services Export As JPEG (JPG)

I noticed that SSRS for SQL 2008 R2 was missing the option to export in JPEG formats. The reason for this is that JPEG formats don't and will not support Multi-page reports.

however If you are just exporting a nice simple graphic you can add support for exporting the JPEG formats.


  • Logon to the SSRS reporting server 
  • Locate the rsreportserver.config and edit it
  • Under the Configuration/Extensions/Render section 
  • Add 
&ltExtension Name="IMAGE (JPEG)" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRenderer,Microsoft.ReportingServices.ImageRendering"&gt
&ltOverrideNames&gt
&ltName Language="en-US"&gtImage (JPEG)&lt/Name&gt
&lt/OverrideNames&gt
&ltConfiguration&gt
&ltDeviceInfo&gt
&ltOutputFormat&gtJPEG&lt/OutputFormat&gt
&lt/DeviceInfo&gt
&lt/Configuration&gt
&lt/Extension&gt
  • Restart the SQL reporting service 
For more information see this thread on social technet


If you find this article useful please leave me a comment or click on an ad to show your support.

No comments :

Post a Comment