Sunday, July 28, 2013

SSRS reports are blank on Chrome

There is a frustrating issue with SQL 2008 R2 Reporting Services when rendering on Chrome (and Safari) - in that they simply display a completely blank screen.
After eventually convincing the users in question that it wasn’t SQL’s fault, or a problem with the report definition, since they displayed fine on internet explorer, 
I set about tracking down a fix.
Basically though, you need to update the ReportingServices.js file on the report server, as Chrome & Safari render a certain type of element in a slightly different way to IE.
Connect to your Reporting Services server, and find the relevant ReportingServices.js file - this will probably be somewhere like

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

C:\Program Files(x86)\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\js\ReportingServices.js

First up, take a copy of this file - let’s not be silly here and assume this is a 100% foolproof solution!
Next, edit this file in notepad. Do a quick search for PageLoad, to ensure no-one else has already hacked applied this fix, then jump to the bottom of the existing text.
Simply append the following code:

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

Save the file, and restart Reporting Services - you should now find that Chrome displays your reports again.


No comments:

Post a Comment