SSRS 2008 R2 - SSRS 2012 - ReportViewer Reports are blank in Safari and Chrome

Question

I migrated our reporting services from version 2008 to another server version 2008 R2  In version 2008 the reports work fine on Safari  The new version 2008 R2 the reports do not show up at all  All I see is the parameter section and then the report is blank  Same in Chrome  According to Microsoft Safari IS supported if in a limited fashion  The reports are not complex  In fact I created a report that only had a line on it to see if it would show up in Safari but no  that report is completely blank as well  Did anyone make SSRS reports viewable on Safari  Do I have to mess with some kind of a configuration setting

User · Answer

The solution provided by Emanuele worked for me. I could see the report when I accessed it directly from the server but when I used a ReportViewer control on my aspx page, I was unable to see the report. Upon inspecting the rendered HTML, I found a div by the id "ReportViewerGeneral_ctl09" (ReportViewerGeneral is the server id of the report viewer control) which had it's overflow property set to auto.

<div id="ReportViewerGeneral_ctl09" style="height: 100%; width: 100%; overflow: auto; position: relative; ">...</div>

I used the procedure explained by Emanuele to change this to visible as follows:

function pageLoad() {
    var element = document.getElementById("ReportViewerGeneral_ctl09");

    if (element) {
        element.style.overflow = "visible";
    }
}

User · Answer

FYI - none of the above worked for me in 2012 SP1   simple solution was to embed credentials in the shared data source and then tell Safari to trust the SSRS server site  Then it worked great   Took days chasing down supposed solutions like above only to find out integrated security won t work reliably on Safari - you have to mess with the keychain on the mac and then still wouldn t work reliably

User · Answer

I am using Chrome version 21 with SQL 2008 R2 SP1 and none of the above fixes worked for me  Below is the code that did work  as with the other answers I added this bit of code to Append to  C  Program Files Microsoft SQL Server MSRS10 50 MSSQLSERVER Reporting Services ReportManager js ReportingServices js   on the SSRS Server       Fix to allow Chrome to display SSRS Reports function pageLoad          var element   document getElementById  ctl31 ctl09        if  element                 element style overflow    visible

User · Answer

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  see Emanuele Greco s answer   I did not know how to take advantage of Emanuele s suggestion to use the RS ReportViewerHost element  but I solved it using JavaScript   Problem    Solution  Since  overflow  auto  is specified in the style attribute of the div element with id  ctl31 ctl10   we can t override it in a stylesheet file so I resorted to JavaScript  I appended the following code to  C  Program Files Microsoft SQL Server MSRS10 50 MSSQLSERVER Reporting Services ReportManager js ReportingServices js   function FixSafari             var element   document getElementById  ctl31 ctl10        if  element                 element style overflow    visible      default overflow value             Code from http   stackoverflow com questions 9434 how-do-i-add-an-additional-window-onload-event-in-javascript if  window addEventListener     W3C standard       window addEventListener  load   FixSafari  false      NB   not    onload     else if  window attachEvent     Microsoft       window attachEvent  onload   FixSafari       Note   There appears to be a solution for SSRS 2005 that I have not tried but I don t think it is applicable to SSRS 2008 because I can t find the  DocMapAndReportFrame  class

User · Answer

Here is the solution I used for Report Server 2008 R2  It should work regardless of what the Report Server will output for use for in its  id  attribute of the table  I don t think you can always assume it will be  ctl31 fixedTable   I used a mix of the suggestion above and some ways to dynamically load jquery libraries into a page from javascript file found here   On the server go to the directory  C  Program Files Microsoft SQL Server MSRS10 50 MSSQLSERVER Reporting Services ReportManager js  Copy the jquery library jquery-1 6 2 min js into the directory  Create a backup copy of the file ReportingServices js Edit the file  And append this to the bottom of it   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   lt scr     ipt type   text javascript   src      js jquery-1 6 2 min js   gt  lt  scr     ipt gt                        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   gt  tbody  gt  tr last  gt  td last  gt  div                    div css  overflow    visible                   1000                                           initJQuery

User · Answer

You can fix this easily with jQuery - and a little ugly hack  -   I have a asp net page with a ReportViewer user control     lt rsweb ReportViewer ID  ReportViewer1  runat  server       In the document ready event I then start a timer and look for the element which needs the overflow fix  as previous posts      lt script type  text javascript  gt        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        lt   ReportViewer1 ClientID   gt  fixedTable  gt  tbody  gt  tr last  gt  td last  gt  div                   div css  overflow    visible                   1000                      lt  script gt    Better than assuming it has a certain id  You can adjust the timer to whatever you like  I set it to 1000 ms here

User · Answer

I ve used this   Add a script reference to jquery on the Report aspx page   Use the following to link up JQuery to the microsoft events   Used a little bit of Eric s suggestion for setting the overflow     document  ready function          if  navigator userAgent toLowerCase   indexOf  webkit    gt   0                    Sys Application add init function                  var prm   Sys WebForms PageRequestManager getInstance                if   prm get isInAsyncPostBack                      prm add endRequest function                          var divs      table id   fixedTable   gt  tbody  gt  tr last  gt  td last  gt  div                       divs each function  idx  element                              element  css  overflow    visible

User · Answer

Just include SizeToReportContent  true  as shown below   lt rsweb ReportViewer ID  ReportViewer1  runat  server  SizeToReportContent  True

User · Answer

Ultimate solution  works in SSRS 2012 too    Append the following script to the following file  on the SSRS Server  C  Program Files Microsoft SQL Server MSRS10 50 MSSQLSERVER Reporting Services ReportManager js ReportingServices js  function pageLoad             var element   document getElementById  ctl31 ctl10        if  element                 element style overflow    visible              Note  As azzlak noted  the div s name isn t always ctl31 ctl10  For SQL 2012 tryctl32 ctl09 and for 2008 R2 try ctl31 ctl09   If this solution doesn t work  look at the HTML from your browser to see if the script has worked properly changing the overflow auto property to overflow visible     Solution for ReportViewer control  Insert into  aspx page  or into a linked  css file  if available  this style line   reportViewer ctl09     overflow visible  important         Reason  Chrome and Safari render overflow auto in different way respect to IE        SSRS HTML is QuirksMode HTML and depends on IE 5 5 bugs  Non-IE browsers don t have the IE quirksmode and therefore render the HTML correctly   The HTML page produced by SSRS 2008 R2 reports contain a div which has overflow auto style  and it turns report into an invisible report     lt div id  ctl31 ctl10  style  height 100  width 100  overflow auto position relative   gt    I can see reports on Chrome by manually changing overflow auto to overflow visible in the produced webpage using Chrome s Dev Tools  F12      I love Tim s solution  it s easy and working     But there is still a problem  any time the user change parameters  my reports use parameters   AJAX refreshes the div  the overflow auto tag is rewritten  and no script changes it      This technote detail explains what is the problem      This happens because in a page built with AJAX panels  only the AJAX panels change their state  without refreshing the whole page  Consequently  the OnLoad events you applied on the  lt body gt  tag are only fired once  the first time your page loads  After that  changing any of the AJAX panels will not trigger these events anymore    User einarq suggested this solution      Another option is to rename your function to pageLoad  Any functions with this name will be called automatically by asp net ajax if it exists on the page  also after each partial update  If you do this you can also remove the onload attribute from the body tag   So wrote the improved script that is shown in the solution

User · Answer

My solution based on the ideas above   function pageLoad         var element   document querySelector  table id   fixedTable   gt  tbody  gt  tr last-child  gt  td last-child  gt  div        if  element            element style overflow    visible              It s not limited to a certain id plus you don t need to include any other library such as jQuery

[reporting-services] SSRS 2008 R2 - SSRS 2012 - ReportViewer: Reports are blank in Safari and Chrome

Examples related to reporting-services

Examples related to ssrs-2008

Examples related to reportviewer

Examples related to ssrs-2012

Examples related to reporting-services-2012