SSRS - Display interactive report on one single page

Want to have your SSRS report show on a single page without any page breaks?

The way to do this is click on empty space of your report and then in the properties window select the interactive size and set it to '0'

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

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

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/b69220f2-dd87-402e-b3ae-8e4afc397648/#b40811eb-3551-4bcf-aba8-909b3f57792a

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