search cancel

IT Analytics 8.0 reports and dashboards are not fully loaded in the console

book

Article ID: 163167

calendar_today

Updated On:

Products

IT Analytics

Issue/Introduction

In ITMS 8.0, IT Analytics reports and dashboards may have following issue:

The reports contain data, but the format is broken, e.g. the data is populated only on half of the screen or there are missing scrollbars (both vertical and horizontal), icons, etc. The same issue occurs for dashboards. The Cube Browser is working correctly. 

Depending on the settings and the version of Internet Explorer, and/or Microsoft patches for IE, the following message may be displayed: "Browser settings do not allow scripts to run on that page". When the reports are loaded directly on SQL Reporting server, they are populated correctly. 

Cause

Known conflict of SQL reporting server page and one of Microsoft's cumulative security updates for the latest versions of Internet Explorer browser:

http://answers.microsoft.com/en-us/ie/forum/ie10-windows_7/ie-10-ssrs-report-viewer-issue-after-kb2888505/1e82a8b9-dea6-4351-90d3-7f4f47c4fb2a?auth=1

This known issue requires addtional changes in MS SQL Reporting Server ReportViewer.aspx file to be implemented.

The default location path is <installpath>\Microsoft SQL Server\MSRS<VersionOfSQL>.MSSQLSERVER\Reporting Services\ReportServer\Pages\ReportViewer.aspx file

 

Resolution

The solution is applicable for IE10, IE11, and was tested on both SQL 2012 and 2014 Reporting servers.

The browsers were updated to one of the latest Cumulative Security Updates for Internet Explorer 11 for Windows Server 2012 R2 (KB3148198).

To resolve the issue, add the highlited code shown below to the aspx page.

<%@ 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">
  <title><%= GetPageTitle() %></title>
</head>
<body style="margin: 0px; overflow: scroll;">
  <form style="width:100%;height:100%;overflow:auto;" runat="server" ID="ReportViewerForm">
   <asp:ScriptManager ID="AjaxScriptManager" AsyncPostBackTimeout="0" runat="server" />
   <RS:ReportViewerHost ID="ReportViewerControl" runat="server" />
  </form>
  <script language="javascript" type="text/javascript">
Sys.WebForms.PageRequestManager.prototype._destroyTree = function(element) {
    var allnodes = element.getElementsByTagName('*'),
        length = allnodes.length;
    var nodes = new Array(length);
    for (var k = 0; k < length; k++) {
        nodes[k] = allnodes[k];
    }
    for (var j = 0, l = nodes.length; j < l; j++) {
        var node = nodes[j];
        if (node.nodeType === 1) {
            if (node.dispose && typeof (node.dispose) === "function") {
                node.dispose();
            }
            else if (node.control && typeof (node.control.dispose) === "function") {
                node.control.dispose();
            }
            var behaviors = node._behaviors;
            if (behaviors) {
                behaviors = Array.apply(null, behaviors);
               for (var k = behaviors.length - 1; k >= 0; k--) {
                    behaviors[k].dispose();
                }
            }
        }
    }
}
document.getElementById("ReportViewerControl_fixedTable").style.tableLayout = "auto";
</script>
</body>
</html>

 

After adding, save and close the file, and refresh the ITA report page. The ITA report pages will now show a functioning set of vertical & horizontal scrollbars if needed.

Attachments