Tuesday, August 28, 2012

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.

Monday, August 13, 2012

Number of days until XP support expires


Plug this into excel and it will tell you the number of days until XP support expires

=NETWORKDAYS(TODAY(),DATE(2014,4,8))

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