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
&ltName Language="en-US"&gtImage (JPEG)&lt/Name&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