Home Dashboard Directory Help
Search

SQL Server Reporting Services is not compatible with Internet Explorer 11 by Tryout User


Status: 

Active


32
0
Sign in
to vote
Type: Bug
ID: 810527
Opened: 12/3/2013 3:31:37 AM
Access Restriction: Public
4
Workaround(s)
view
15
User(s) can reproduce this bug

Description

Report toolbar—the one with report controls and export feature—is displayed on multiple lines in Internet Explorer 11, while in Internet Explorer 10 or earlier the toolbar was displayed in a single line.
Details
Sign in to post a comment.
Posted by Ricardo Matos Matosdotnet on 3/28/2014 at 1:06 AM
Hello there,

the latest cumulative packages do solve this issue for SQL Server 2012.

Unfortunatly seems still not to be the case for SQL Server 2008 R2. Is it planned to release it anytime soon?

Best Regards.
Posted by Matt VC on 3/12/2014 at 11:25 AM
@MSSupport

I noticed there were multiple fixes to be downloaded from the http://support.microsoft.com/kb/2917531 page, I'm guessing it's SQLServer2012_SP1_CU8_2917531_11_0_3401_x64 for this IE 11 issue?
Posted by Omair Imran on 2/7/2014 at 6:06 AM
Hi

Is there any update for SQL Server 2008 R2 which uses v10.0.0?

As a work around I have managed to sort the multiline issue by replacing display = "inline-block" to just "inline" at page level. The print button is still pending.

Thanks in advance.
Posted by Microsoft on 1/29/2014 at 2:17 PM
Hello -

We are happy to inform that the problem was fixed in CU8 for SQL Server 2012 Sp1.
Please visit the http://support.microsoft.com/kb/2917531 to get the update.

Mariusz Cichomski
Program Manager
SQL Server, Microsoft
Posted by Bluey47 on 1/27/2014 at 7:29 PM
Michael, I completely agree. MS needs to release an actual solution for this in a service pack.

They also need to address the obvious issues with their internal testing of IE and SSRS. Especially if they think businesses are going to continue using such poorly supported solutions. SSRS is only supported to be used with IE, we therefore require Microsoft to check that future versions of IE support SSRS. If there are bugs they need to be fixed before the new version of IE is forced onto computers through windows update and not years after.

The work around I posted shouldn’t be necessary if MS handled this better, however it has prevented me talking hundreds of clients through how and why they need to add our site to the compatibility list in IE. Luckily only a few use the print control.
Posted by michael12345 on 1/27/2014 at 5:54 PM
Thanks for the workaround Blue47 and we'll keep that up our sleeves if we need it. However, I want to emphasize to Microsoft that we really need a vendor-supported fix for this. I have multiple instances of SSRS to administer and rolling out manual hotfixes to javascript files will make it a maintenance headache.

When we've done this sort of thing in the past, we've gotten into all sorts of trouble downstream either failing to re-apply the fix in future deployments, or inadvertently applying a new fix that overwrites the old one. The latest version of IE should work with the latest version of SSRS.
Posted by Bluey47 on 1/27/2014 at 5:03 PM
I have just added another workaround which corrects the IE11 Navigation bar issue without requiring compatibility mode. Unfortunately it doesn’t correct the print control issue which still requires compatibility mode.
Posted by AmosOtis on 1/13/2014 at 5:16 PM
unfortunately for me the "workaround" is untenable. I have an MVC site using "bootstrap" and "font awesome" on the same server with Reporting Services. When in compatibility mode the SSRS reports then look fine but my MVC site is not functional. When in "normal" mode the MVC site works fine but as stated here SSRS reports look stupid.

Please Microsoft make SSRS work with IE 11 natively!

Thanks
Posted by michael12345 on 12/18/2013 at 8:07 PM
The workaround resolved the toolbar display issue for me - but it's not really a suitable long-term fix. We have quite a wide community of web users and offering instructions on how to add our domain to the compatibility view list is just more unwanted support overhead. Also, compatibility view appears to break other parts of our website.

I really hope that there is an SQL service pack or hotfix on the way.
Posted by Shaun Baggett on 12/4/2013 at 4:48 PM
I also get the dodgy toolbar after upgrading to Windows 8.1. This installed IE 11 as part of the upgrade from Windows 8.0
My SSRS (2012) report server is running locally on my Windows 8.1 machine.
Sign in to post a workaround.
Posted by sammysooser on 2/24/2014 at 11:44 AM
I run SSRS 10.50.4000.0 with the same problem. Got the multi-line problem fixed by changing C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\Pages\ReportViewer.aspx from

<%@ Register TagPrefix="RS" Namespace="Microsoft.ReportingServices.WebServer" Assembly="ReportingServicesWebServer" %>
<%@ Page Language="C#" AutoEventWireup="true" Inherits="Microsoft.ReportingServices.WebServer.ReportViewerPage" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head id="headID" runat="server">
<meta http-equiv="X-UA-Compatible" content="IE=5">

TO

<%@ Register TagPrefix="RS" Namespace="Microsoft.ReportingServices.WebServer" Assembly="ReportingServicesWebServer" %>
<%@ Page Language="C#" AutoEventWireup="true" Inherits="Microsoft.ReportingServices.WebServer.ReportViewerPage" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head id="headID" runat="server">
<meta http-equiv="X-UA-Compatible" content="IE=10">


but still have the printing problem


Posted by Bluey47 on 1/27/2014 at 7:13 PM
There was a bug in the code I posted below and there is no edit ability on this page.

So modify the function with this code instead.

function pageLoad() {
    var i, el = document.getElementById("ctl32_ctl09"),
        navBar = document.getElementById('ctl32_ctl05'),
        navBarTables, navBarTable;

    //Fix Chrome invisible report
    if (el)
        el.style.overflow = "visible";


    if (navBar) {
        navBarTables = navBar.getElementsByTagName('table');
        //Fix IE11 Navigation Bar over multiple rows
        for (i = 0; i < navBarTables.length; i++) {
            navBarTable = navBarTables[i];
            if (!!navBarTable.className.match(/WidgetSetSpacer/) || !!navBarTable.className.match(/WidgetShortSpacer/)) {
                navBarTable.style.Display = '';
            }
        }
    }
}
Posted by Bluey47 on 1/27/2014 at 4:58 PM
Our brilliant web developer re-worked the Chrome fix to also correct the IE11 Navigation tool bar multi-row issue in SSRS 2012 so that compatibility mode isn’t required unless you want the print control.
The following instructions implement the Chrome fix and IE11 fix into an unmodified ReportingServices.js on the Reporting server.
1)    Create a backup copy of ReportingServices.js (C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportManager\js)

2)    Edit ReportingServices.js Find the fixChrome function. Rename the fixChrome function to pageLoad. This causes the function to get called each time the page changes and is required to make the chrome fix actually work.

3)    Modify the pageLoad function to the following

function pageLoad() {
    var i, el = document.getElementById("ctl32_ctl09"),
        navBar = document.getElementById('ctl32_ctl05'),
        navBarTables = navBar.getElementsByTagName('table'),
        navBarTable;

    //Fix Chrome invisible report
    if (el)
        el.style.overflow = "visible";

    //Fix IE11 Navigation Bar over multiple rows
    for (i = 0; i < navBarTables.length; i++) {
        navBarTable = navBarTables[i];
        if (!!navBarTable.className.match(/WidgetSetSpacer/) || !!navBarTable.className.match(/WidgetShortSpacer/)) {
            navBarTable.style.Display = '';
        }
    }
    
}
Posted by Shaun Baggett on 12/5/2013 at 12:15 PM
You can get the SSRS toolbar to behave if you run IE 11 in Compatibility mode.
This is now under Tools/Compatibility View Settings. Then add your site to the list.
File Name Submitted By Submitted On File Size  
OLAP vertical.JPG 12/3/2013 33 KB
OLAP horizontal.JPG 12/3/2013 29 KB