SSRS 2012 reports doesn’t render on Chrome or Safari browser


Problem: Deploying SSRS 2012 reports works on Internet Explorer but doesn’t render on Chrome or Safari browser and reports do not show up at all

Solution:

This is a known issue. The problem is that a div tag has the style "overflow: auto" which apparently is not implemented well with WebKit which is used by Safari and Chrome.

There are couple of options to resolve the issue:

1 - If users are accessing Reports via some web application rather then exposing directly to Report Manager then rendering on Chrome or Safari should not be an issue. 

2 - But if users are opening Report Manager directly using Chrome then there is workaround which resolve the issue by changing ReportingServices.js file parameter on SSRS server

You can find ReportingServices.js file on SSRS server and it should be located at below file path

"C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager\js\ReportingServices.js"


Step 1 - Create a backup copy of the file ReportingServices.js Edit the file. 

Step2 - Append below script to the bottom of ReportingServices.js file as below

var jQueryScriptOutputted = false;
function initJQuery() {

    //if the jQuery object isn't available
    if (typeof(jQuery) == 'undefined') {


        if (! jQueryScriptOutputted) {
            //only output the script once..
            jQueryScriptOutputted = true;

            //output the script 
            document.write("<scr" + "ipt type=\"text/javascript\" src=\"../js/jquery-1.6.2.min.js\"></scr" + "ipt>");
         }
        setTimeout("initJQuery()", 50);
    } else {

        $(function() {     

        // Bug-fix on Chrome and Safari etc (webkit)
        if ($.browser.webkit) {

            // Start timer to make sure overflow is set to visible
             setInterval(function () {
                var div = $('table[id*=_fixedTable] > tbody > tr:last > td:last > div')

                div.css('overflow', 'visible');
            }, 1000);
        }

        });
    }        
}

initJQuery();

You can also refer below blogs:



Comments

Popular posts from this blog

Calculating Age of the person in T-SQL

How to Troubleshoot Subscription issue in Reporting Services

MDX Queries - Current Day - Month and Year