1

I am hoping someone has an idea about what I am experiencing.

I've worked with various versions of the Report Viewer control (both WinForms and Web) over the years and have just started trying to use the latest HTML5 based version in an ASP .NET Wed Forms project.

My environment is as follows: Dev laptop with Windows 7 and SQL Server 2014 Including SSRS. Various remote servers with 2008R2, 2014 and 2016 Reporting Services on them.

I've followed this tutorial page from the Microsoft Docs: https://learn.microsoft.com/en-us/sql/reporting-services/application-integration/using-the-webforms-reportviewer-control, and have set up a page that points at remote server reports.

Code Behind:

protected void Page_Init(object sender, EventArgs e)
{
    if (!Page.IsPostBack)
    {                
        rv14.ProcessingMode = ProcessingMode.Remote;
        ServerReport serverReport = rv14.ServerReport;

       // A 2016 Report
       serverReport.ReportServerUrl = new Uri("http://2016server/reportserver");
       serverReport.ReportPath = "/Sports";

       // A 2014 Report
       // serverReport.ReportServerUrl = new Uri("http://2014server/reportserver");
       // serverReport.ReportPath = "/SQL2014DemoReports/VertBar";

       // A 2008R2 Report
       // serverReport.ReportServerUrl = new Uri("http://2008R2server/Reportserver");
       // serverReport.ReportPath = "/DemoReports/VertBar";

   } 
}

ASPX

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Reports.aspx.cs" Inherits="WebNew.Reports" %>    
<%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Reports</title>
</head>
<body>
    <form id="form1" runat="server">
    <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
        <rsweb:ReportViewer ID="rv14" runat="server" Width="100%" Height="100%"></rsweb:ReportViewer>
    </form>
</body>
</html>

When I run the page, the new HTML based toolbar renders and I get and I get the "loading" mini dialog showing, but then nothing. No report body rendered. The report currently uncommented in the code is a simple list of sports a couple of pages long, nothing complex.

I can tell that the server was contacted and replied as I am seeing the pagination control indicating that there is more than one page, and if I then use any of the export controls, such as PDF, the PDF DOES have the correct rendered output in it.

It is simply not showing in my web page.

I've tried IE (11), Chrome (58) and Firefox (49) and all display the same behaviour. It does not matter which of the servers I target or if I connect to my local instance.

Has anyone seen this behaviour, have any pointers to what might be happening, or a good way of trying to debug?

Many thanks

ChromaticRanger
  • 140
  • 3
  • 16

2 Answers2

4

OK, so I stumbled across a solution to what I was seeing. It would seem that the problem is to do with what the viewer is contained within.

If I wrap the viewer in a DIV and set it's height to 100 vertical height then the viewer does correctly show its content. Previously it must have effectively been in a container of height zero.

Working ASPX code looks like this:

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>2016 Report Viewer Test</title>
</head>
<body>
    <form id="form1" runat="server">
        <asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>
        <div style="height:100vh">            
            <rsweb:ReportViewer 
                ID="rv14" 
                runat="server" 
                Width="100%" 
                Height="100%">
            </rsweb:ReportViewer>
        </div>
    </form>
</body>
</html>

Hope this helps someone one day. :-)

ChromaticRanger
  • 140
  • 3
  • 16
3

Add this, worked for me.

rv14.SizeToReportContent = true;
Waner A. Peña Sánchez
  • 371
  • 3
  • 9