4

I have a SSRS2008R2 report that runs just fine through Chrome and Firefox but will not run at all in Internet Explorer. I have tried IE9, IE10, and IE11 but I get the same results. I just get the green 'Loading' circle but the report never opens. I can run exactly the same report with the same parameters in Chrome and Firefox and it returns within about 2 seconds. This is a multi-page report with page breaks set. Other than that, I cannot think of anything unusual about the report.

Any ideas why this is happening?

Derrick Van Hoeter
  • 157
  • 2
  • 3
  • 10

3 Answers3

3

I've had the same issue with IE10 and IE11 (don't know about IE9) and if I put the browser in compatibility mode the report ran fine.

Here's how to put IE10 into compatibility mode http://techathlon.com/internet-explorer-10-run-compatibility-mode/

Update

This issue can also be fixed by upgrading to the Reporting Services that comes with SQL Server 2012.

energ1ser
  • 2,703
  • 4
  • 24
  • 31
  • Thanks for the update. We were planning on migrating to MSSQL2012/SSRS2012 in the near future. Looks like the future needs to be nearer than planned for. – Derrick Van Hoeter Feb 28 '14 at 03:40
  • I had to take IE9 OUT of compatibility mode in order to get the report to work. But then I have to put IE IN compatibility mode in order to access any of the report management options. Nice work, Microsoft. – devlin carnate Jul 16 '14 at 15:14
1

You might need to make sure to your SQL server is upgraded to Service Pack 2. There are several issues compatibility issues with ie10+ and SQL Server 2008R2 RTM.

ReportViewer's Print Button Incompatible with IE 10?

The following table lists the major releases of SQL Server 2008 R2.
Release Product version
SQL Server 2008 R2 Service Pack 2   10.50.4000.0
SQL Server 2008 R2 Service Pack 1   10.50.2500.0
SQL Server 2008 R2 RTM  10.50.1600.1

Microsoft Article on Server Version

Connect to the instance of SQL Server, and then run the following query:

Select @@version
Community
  • 1
  • 1
wruckie
  • 1,717
  • 1
  • 23
  • 34
  • The SQL Server servers in question are already at version 10.50.4000.0 (SP2). Also, the report runs fine when running IE in compatibility mode. However, the site that it is running on cannot be run in compatibility mode as that mode is incompatible with other parts of the site. – Derrick Van Hoeter Feb 25 '14 at 04:42
0

For IE11, add the report server to the compatibility view list.

Alt-key>Tools>Compatibility View Settings>"Add this website:"(the SSRS website should already be listed)>Add. Select "Display intranet sites in compatibility view" > Close.

William Hug
  • 21
  • 2