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";
} }
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.
