SSRS list view bug in Internet Explorer 11 with SQL 2016 SP1 CU3 update

Issue: 
If you happen use SSRS with IE 11 and you have SQL 2016 SP1 with CU3 installed and then try to switch to 'list view' you'll get an error message about could not load folder contents

Workaround:
Go back and just use 'Tile View' or  switch to Chrome (doesn't seem to be affected) or Uninstall CU3 and go back to CU2.

I have reported this to Microsoft but no response yet.

More info:
https://social.technet.microsoft.com/

https://connect.microsoft.com

If you find this article useful please leave me a comment.

SSRS The attempt to connect to the report server failed

turns there was no closing tab in the web.config for  

I closed the section with

and then restarted SSRS and this fixed the issue.

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

How to get SSRS reports working in Google Chrome

1. On your SSRS server locate the  ReportingServices.js file. Normally you can find it in "C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager\js\ReportingServices.js"
2. Edit the file, append this to the end of the file 
   

   function pageLoad() {    
       var element = document.getElementById("ctl31_ctl09");
       if (element) 
       {
           element.style.overflow = "visible"; 
       } }

Test a report.

Many thanks to the guys on StackOverflow for that one.
http://stackoverflow.com/questions/5428017/cannot-view-ssrs-2008-r2-ssrs-2012-reports-in-safari-chrome-but-works-fine-in

Notes: Any activex control such as Print Control and Zoom Controls will still not work in Chrome. This is because only Internet explorer will support the use of such controls.

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

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.