E
EntropicTempest
Guest
I have looked just about everywhere for a solution to this issue and have not found one that has worked for me yet. I have a reporting server (2008 R2) set up on our hosting server. I have created a report from scratch using the report builder, tested it out while logging into the report server with its URL and it successfully generates reports.
When I try to view the report from our MVC application, only the reports toolbar renders (showing export, print, pages, and the view report button). It shows that it is "Loading", and after it completes its just a blank report, but it shows the correct parameters on the toolbar, and if I change the name of the parameters in the code it returns an error stating the parameter doesnt exist; so I know the address user/pw information is correct.
Code and markup for the page
<%@ Page Title="" Language="C#" MasterPageFile="~/Views/Shared/Site.Master" Inherits="System.Web.Mvc.ViewPage" %>
<%@ Import Namespace="Comp.Proj.Core.Model"%>
<%@ Import Namespace="Comp.Proj.Core.Service" %>
<%@ Import Namespace="Microsoft.Reporting.WebForms" %>
<%@ Import Namespace="System.Security.Principal" %>
<%@ Import Namespace="System.Net" %>
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server
/Reporting Back to Reports / <%=ViewData["Report"]%>
<form action="/Reporting/DateViewer" method="get
Start Date: <input type="text" name="start" class="datepicker" value="<%=ViewData["Start"] %>" />
End Date: <input type="text" name="end" class="datepicker" value="<%=ViewData["End"] %>" />
<input type="hidden" name="id" value="<%=ViewData["Report"] %>" />
<input type="submit" class="button" value="Run" />
</form>
<script runat="server" language="C#
protected void Page_Load(object sender, EventArgs e)
{
try
{
if(!IsPostBack){
if (ViewData["Start"] != null)
{
var param = new List<ReportParameter>();
var start = new ReportParameter("start", ViewData["Start"].ToString());
var end = new ReportParameter("end", ViewData["End"].ToString());
var region = new ReportParameter("region", "2");
param.Add(start);
param.Add(end);
param.Add(region);
ReportViewer1.Width = 1100;
ReportViewer1.Height = 900;
ReportViewer1.ShowCredentialPrompts = false;
ReportViewer1.ShowDocumentMapButton = false;
ReportViewer1.ShowExportControls = true;
ReportViewer1.ShowFindControls = false;
ReportViewer1.ShowPrintButton = true;
ReportViewer1.ShowPromptAreaButton = false;
ReportViewer1.ShowRefreshButton = false;
ReportViewer1.ShowToolBar = true;
ReportViewer1.ShowZoomControl = false;
ReportViewer1.SizeToReportContent = true;
ReportViewer1.ProcessingMode = ProcessingMode.Remote;
IReportServerCredentials irsc =
new CustomReportCredentials(ConfigurationManager.AppSettings["ReportServerUser"],
ConfigurationManager.AppSettings["ReportServerPassword"], "SERVERNAME");
ReportViewer1.ServerReport.ReportServerCredentials = irsc;
ReportViewer1.ServerReport.ReportServerUrl =
new Uri(string.Format("http://{0}/ReportServer",
ConfigurationManager.AppSettings["ReportServerUrl"]));
ReportViewer1.ServerReport.ReportPath = string.Format("/{0}", ViewData["Report"]);
ReportViewer1.ServerReport.SetParameters(param);
ReportViewer1.ShowReportBody = true;
ReportViewer1.ServerReport.Refresh();
}
}
}catch (Exception ex)
{
Response.Write(ex.Message);
}
}
</script>
<form id="form1" runat="server
<asp:ScriptManager ID="ScriptManager1" runat="server
</asp:ScriptManager>
<rsweb:ReportViewer ID="ReportViewer1" runat="server"
/>
</form>
<assemblies>
<add assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
<add assembly="Microsoft.ReportViewer.Common, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
</assemblies>
<buildProviders>
<add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</buildProviders>
<system.webServer>
<handlers>
<add name="ReportViewerWebControlHandler" preCondition="integratedMode" verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</handlers>
</system.webServer>
Continue reading...
When I try to view the report from our MVC application, only the reports toolbar renders (showing export, print, pages, and the view report button). It shows that it is "Loading", and after it completes its just a blank report, but it shows the correct parameters on the toolbar, and if I change the name of the parameters in the code it returns an error stating the parameter doesnt exist; so I know the address user/pw information is correct.
Code and markup for the page
<%@ Page Title="" Language="C#" MasterPageFile="~/Views/Shared/Site.Master" Inherits="System.Web.Mvc.ViewPage" %>
<%@ Import Namespace="Comp.Proj.Core.Model"%>
<%@ Import Namespace="Comp.Proj.Core.Service" %>
<%@ Import Namespace="Microsoft.Reporting.WebForms" %>
<%@ Import Namespace="System.Security.Principal" %>
<%@ Import Namespace="System.Net" %>
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server
/Reporting Back to Reports / <%=ViewData["Report"]%>
<form action="/Reporting/DateViewer" method="get
Start Date: <input type="text" name="start" class="datepicker" value="<%=ViewData["Start"] %>" />
End Date: <input type="text" name="end" class="datepicker" value="<%=ViewData["End"] %>" />
<input type="hidden" name="id" value="<%=ViewData["Report"] %>" />
<input type="submit" class="button" value="Run" />
</form>
<script runat="server" language="C#
protected void Page_Load(object sender, EventArgs e)
{
try
{
if(!IsPostBack){
if (ViewData["Start"] != null)
{
var param = new List<ReportParameter>();
var start = new ReportParameter("start", ViewData["Start"].ToString());
var end = new ReportParameter("end", ViewData["End"].ToString());
var region = new ReportParameter("region", "2");
param.Add(start);
param.Add(end);
param.Add(region);
ReportViewer1.Width = 1100;
ReportViewer1.Height = 900;
ReportViewer1.ShowCredentialPrompts = false;
ReportViewer1.ShowDocumentMapButton = false;
ReportViewer1.ShowExportControls = true;
ReportViewer1.ShowFindControls = false;
ReportViewer1.ShowPrintButton = true;
ReportViewer1.ShowPromptAreaButton = false;
ReportViewer1.ShowRefreshButton = false;
ReportViewer1.ShowToolBar = true;
ReportViewer1.ShowZoomControl = false;
ReportViewer1.SizeToReportContent = true;
ReportViewer1.ProcessingMode = ProcessingMode.Remote;
IReportServerCredentials irsc =
new CustomReportCredentials(ConfigurationManager.AppSettings["ReportServerUser"],
ConfigurationManager.AppSettings["ReportServerPassword"], "SERVERNAME");
ReportViewer1.ServerReport.ReportServerCredentials = irsc;
ReportViewer1.ServerReport.ReportServerUrl =
new Uri(string.Format("http://{0}/ReportServer",
ConfigurationManager.AppSettings["ReportServerUrl"]));
ReportViewer1.ServerReport.ReportPath = string.Format("/{0}", ViewData["Report"]);
ReportViewer1.ServerReport.SetParameters(param);
ReportViewer1.ShowReportBody = true;
ReportViewer1.ServerReport.Refresh();
}
}
}catch (Exception ex)
{
Response.Write(ex.Message);
}
}
</script>
<form id="form1" runat="server
<asp:ScriptManager ID="ScriptManager1" runat="server
</asp:ScriptManager>
<rsweb:ReportViewer ID="ReportViewer1" runat="server"
/>
</form>
<assemblies>
<add assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
<add assembly="Microsoft.ReportViewer.Common, Version=10.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
</assemblies>
<buildProviders>
<add extension=".rdlc" type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</buildProviders>
<system.webServer>
<handlers>
<add name="ReportViewerWebControlHandler" preCondition="integratedMode" verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</handlers>
</system.webServer>
Continue reading...