C# - MVC 2 And The Reportviewer With SSRS 2005 - White Page, No Error
Nov 15, 2010
I am having an issue with my reportviewer where nothing is visible, not even the control. If I add other content, it shows, but the reportviewer is not. I am using the 9.0.0.0 version of the control with SSRS 2005 inside an MVC 2.0 application. I have built and deployed the report to the server. I have confirmed by looking on the report server and running it there.
My app is MVC 2.0
I have added a regular webforms page into the root of the website. I put it in a form, runat=server, and enabled viewstate. I have added the .aspx routing exception My code behind is set up similarly to every example I can find. My webconfig is configured (maybe that is where my issue is) I set up a manual test by forcing the correct values in and I get the same blank page. I have a reference to the 9.0.0.0 versions of Microsoft.ReportViewer.WebForms and Microsoft.ReportViewer.Common and as you can see my web.config matches my references.
The page appears white - no control is visible. No errors are thrown. As I remembered it, there should at least be a blank Reportviewer control on the page, however there isn't anything there at all.
A few other oddities - If I remove the parameter setting, no error occurrs. I also added code to send in credentials, but that did not work, even when sending in the credentials for the administrator account.
Report.aspx
<%@ Page Language="C#" AutoEventWireup="true" ViewStateMode="Enabled" CodeBehind="Report.aspx.cs" Inherits="MySite.Web.Report" %>
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
<html>
<body>
<form id="form1" runat="server">
<rsweb:ReportViewer ID="reportViewer" EnableViewState="True" runat="server" />
</form>
</body>
</html>
Routing Exceptions
routes.IgnoreRoute("{resource}.axd/{*pathInfo}");
routes.IgnoreRoute("{resource}.aspx/{*pathInfo}");
Code Behind
protected void Page_Load(object sender, EventArgs e)
{
var qs = ReportQueryString.Parse(Request.QueryString["R"]);
reportViewer.ServerReport.ReportServerUrl = ConfigurationHelper.Reports.ReportServerUrl;
reportViewer.ServerReport.ReportPath = String.Format(ConfigurationHelper.Reports.ReportPath, qs.ReportName);
var result = from p in qs.Parameters
select new ReportParameter(p.Key, p.Value);
reportViewer.ServerReport.SetParameters(result);
reportViewer.ServerReport.Refresh();
}
Web.config
<compilation debug="true" targetFramework="4.0">
<assemblies>
<add assembly="System.Web.Abstractions, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add assembly="System.Web.Routing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add assembly="System.Web.Mvc, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" />
<add assembly="Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
<add assembly="Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A" />
</assemblies>
<buildProviders>
<add type="Microsoft.Reporting.RdlBuildProvider, Microsoft.ReportViewer.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" extension=".rdl" />
</buildProviders>
</compilation>
<pages>
<namespaces>
<add namespace="Microsoft.Web.Mvc" />
<add namespace="System.Web.Mvc" />
<add namespace="System.Web.Mvc.Ajax" />
<add namespace="System.Web.Mvc.Html" />
<add namespace="System.Web.Routing" />
<add namespace="System.Drawing" />
</namespaces>
</pages>
<httpHandlers>
<add type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" path="Reserved.ReportViewerWebControl.axd" verb="*" />
</httpHandlers>
EDIT:
As requested, here is the page source. On a side note, I am using Chrome, but I did try IE with the same result.
<html>
<body>
<form method="post" action="Report.aspx?R=rYeJ28xc7emx1PJPgiRkOi1lXjmmNE6pF7aJrEJ443w*" id="form1">
<div class="aspNetHidden">
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwULLTE0NzMwNTUwMTgPZBYCAgEPZBYCAgEPFCsABA8WAh4OUmVuZGVyaW5nU3RhdGULKZUBTWljcm9zb2Z0LlJlcG9ydGluZy5XZWJGb3Jtcy5SZXBvcnRSZW5kZXJpbmdTdGF0ZSwgTWljcm9zb2Z0LlJlcG9ydFZpZXdlci5XZWJGb3JtcywgVmVyc2lvbj05LjAuMC4wLCBDdWx0dXJlPW5ldXRyYWwsIFB1YmxpY0tleVRva2VuPWIwM2Y1ZjdmMTFkNTBhM2ECZCgpWFN5c3RlbS5HdWlkLCBtc2NvcmxpYiwgVmVyc2lvbj00LjAuMC4wLCBDdWx0dXJlPW5ldXRyYWwsIFB1YmxpY0tleVRva2VuPWI3N2E1YzU2MTkzNGUwODkkOTQ5NWQxOTEtMmVmMy00OTJlLTk1ZTgtMzRhZDBkYWI4ZGM4AgEUKwABFCsAAgIBZBYKZg8PFgIeB1Zpc2libGVoZGQCAQ8PFgIfAWhkFgICCA8PFgIfAWhkZAIGDxYCHgVWYWx1ZQUBMGQCBw8WAh8CBQVmYWxzZWQCCA8WAh8CBQVmYWxzZWRkvlE8tEXOwYRIWVLykp+GFwUxbrW+MAtpUdojqbM994U=" />
</div>
<script src="/Reserved.ReportViewerWebControl.axd?OpType=Resource&Version=9.0.30729.4402&Name=Microsoft.Reporting.WebForms.Scripts.ReportViewer.js" type="text/javascript"></script>
<div class="aspNetHidden">
<input type="hidden" name="__EVENTTARGET" id="__EVENTTARGET" value="" />
<input type="hidden" name="__EVENTARGUMENT" id="__EVENTARGUMENT" value="" />
<input type="hidden" name="__EVENTVALIDATION" id="__EVENTVALIDATION" value="/wEWBgLgrv+UCwL8sqiiBgL8sqyiBgL8srCiBgL8srSiBgL8stiiBkbkdSlUJxfVD65mS2OQpfO01z367cPQhXOdmZguuzmc" />
</div>
<div id="reportViewer" style="display:inline-block;height:400px;width:100%;">
<Script language="javascript"><!--
if (document.getElementById('reportViewer') != null)
{
document.getElementById('reportViewer').ClientController = new RSClientController("reportViewer_ctl03", "ReportFramereportViewer", "/Reserved.ReportViewerWebControl.axd?Mode=true&ReportID=b003c2a678b44c71b949617a693d4f8c&ControlID=9495d1912ef3492e95e834ad0dab8dc8&Culture=1033&UICulture=1033&ReportStack=1&OpType=DocMapArea&Controller=reportViewer&RootLabel=&BackColor=%23ECE9D8&Border=1px+Black+Solid&Font=font-family%3aVerdana%3bfont-size%3a8pt%3b", "25%", false, "/Reserved.ReportViewerWebControl.axd?Mode=true&ReportID=2558c6ccaa09444ea46bd3062bc553dd&ControlID=9495d1912ef3492e95e834ad0dab8dc8&Culture=1033&UICulture=1033&ReportStack=1&OpType=ReportArea&Controller=reportViewer&LinkTarget=_top", true, true, true, true, true, true, "reportViewer_ctl06", false, "/Reserved.ReportViewerWebControl.axd?Mode=true&ReportID=66fb690f271c48d59bc881cd0f07421d&ControlID=9495d1912ef3492e95e834ad0dab8dc8&Culture=1033&UICulture=1033&ReportStack=1&OpType=Export&FileName=&ContentDisposition=OnlyHtmlInline&Format=", "PrintFramereportViewer", "/Reserved.ReportViewerWebControl.axd?Mode=true&ReportID=c1c1698c78c7476b8a04e03424d3a36c&ControlID=9495d1912ef3492e95e834ad0dab8dc8&Culture=1033&UICulture=1033&ReportStack=1&OpType=PrintHtml", "reportViewer_ctl07", "reportViewer_ctl00", "reportViewer_ctl08");
document.getElementById('reportViewer').ClientController.PostBackAction =
function(actionType, actionParam)
{
document.getElementById("reportViewer_ctl04").value = actionType;
document.getElementById("reportViewer_ctl05").value = actionParam;
doPostBack('reportViewer','');
};
}
--></Script><input type="hidden" name="reportViewer$ctl04" id="reportViewer_ctl04" /><input type="hidden" name="reportViewer$ctl05" id="reportViewer_ctl05" /><input type="hidden" name="reportViewer$ctl06" id="reportViewer_ctl06" value="0" /><input type="hidden" name="reportViewer$ctl07" id="reportViewer_ctl07" value="false" /><input type="hidden" name="reportViewer$ctl08" id="reportViewer_ctl08" value="false" /><noscript>
Your browser does not support scripts or has been configured not to allow scripts.
</noscript><Script language="javascript"><!--
document.getElementById('reportViewer').ClientController.CustomOnReportLoaded = function() {};
document.getElementById('reportViewer').ClientController.CustomOnAsyncPageChange = function() {};
document.getElementById('reportViewer').ClientController.CustomOnDocMapVisibilityChange = function() {};
document.getElementById('reportViewer').ClientController.CustomOnPromptAreaVisibilityChange = function() {};
document.getElementById('reportViewer').ClientController.CustomOnReloadDocMap = function() {};
--></Script>
</div><iframe name="reportViewerTouchSession0" id="reportViewerTouchSession0" onload="if (frames['reportViewerTouchSession0'].location != 'javascript:''') frames['reportViewerTouchSession0'].location.replace('javascript:''');" src="javascript:''" style="position:absolute;width:0;height:0;border-width:0;visibility:hidden;">
</iframe><script type="text/javascript">
setTimeout("frames['reportViewerTouchSession0'].location.replace('\/Reserved.ReportViewerWebControl.axd?Mode=true&ReportID=dd0df78cbe0d4c119d2af4e5a13a33b7&ControlID=9495d1912ef3492e95e834ad0dab8dc8&Culture=1033&UICulture=1033&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodreportViewerTouchSession0&CacheSeed=' + encodeURIComponent(Date()));", 0);function KeepAliveMethodreportViewerTouchSession0() {setTimeout("frames['reportViewerTouchSession0'].location.replace('\/Reserved.ReportViewerWebControl.axd?Mode=true&ReportID=dd0df78cbe0d4c119d2af4e5a13a33b7&ControlID=9495d1912ef3492e95e834ad0dab8dc8&Culture=1033&UICulture=1033&ReportStack=1&OpType=SessionKeepAlive&TimerMethod=KeepAliveMethodreportViewerTouchSession0&CacheSeed=' + encodeURIComponent(Date()));", 1140000);}
</script><Script language="javascript"><!--
document.getElementById('reportViewer').ClientController.ShowInitialWaitFrame();
--></Script>
<script type="text/javascript">
//<![CDATA[
var theForm = document.forms['form1'];
if (!theForm) {
theForm = document.form1;
}
function __doPostBack(eventTarget, eventArgument) {
if (!theForm.onsubmit || (theForm.onsubmit() != false)) {
theForm.__EVENTTARGET.value = eventTarget;
theForm.__EVENTARGUMENT.value = eventArgument;
theForm.submit();
}
}
//]]>
</script>
</form>
</body>
</html>
View 1 Replies
Similar Messages:
Jan 13, 2011
I am getting "ASP.NET Session Expired" error when viewing SQL Server 2008 reports using the Microsoft ReportViewer web control. I found this article http://balanagaraj.wordpress.com/2009/09/25/session-has-expired-in-asp-net/ which suggests to use one worker process in IIS application pool, but that may affect performance, is there any other solution for this? I tried setting "AsyncRendering" to false already and that didn't work.
View 2 Replies
Oct 4, 2010
I have been developing reports using BIDS 2005 and deploying them to a report server on my development machine.
These reports can be called succesfully from both the report manager and my asp.net website.Everything has been working fine.
Some time back some early versions of the reports were deployed to a test server in order that they could be tested away from the development machine. The reports processed successfully.Today I have uploaded a number of completed reports (using Report Manager) to the test server and am getting an error message for each one when I try to run it direct from Report Manager.
The message is: "An error has occurred during report processing Common Language Rutime detected an invalid program"
I've been trying to resolve this for a few hours now and am getting nowhere. Google has thrown up some finds on the error message but these seem to refer to people having issues with the compilation of large methods or forms with a very high number of controls.I can't see this being appropriate because most of the reports are relatively simple and the most complex probably has only 100 different controls.
View 1 Replies
Nov 10, 2010
I have a number of .rdl SSRS 2000 files that I want to convert to SSRS 2005 .rdl files.
I have installed BIDS 2005 and have opened the project in BIDS 2005.
When i open any file individually I get about 200 error messages.
Does anyone know what I need to do to convert the .rdl files to SSRS 2005?
View 2 Replies
Dec 29, 2010
I have SSRS (discountasp.net) and I currently display reports on my web page using Reportviewer and use .net code to authenticate them (username/password). Recently I have bought VPS (Windows Server 2008 Web Edition + .net 4.0) and would like to use SSRS the same way as above. I have never done this before so need some guidance on that just to ensure the server is still "safe". Below are some questions that I think are related but feel free to add other comments that I didn't think about.
1) Set up new user? What permissions are required?
2) Configure SSRS to for external connections?
3) Firewall?
View 2 Replies
Mar 26, 2010
Starting to look into an web app thet uses the ReportViewer to display SSRS reports. This is for SSRS 2008. What would be the best way to go about the follwoing: The reports are sales reports so only ceratin people will get to see certain reports.
1: If a user opens a report which they can see and that report has a subreport which they can't, will the subreport still be viewable?
2: If the webapp will be used by many different people internally and eventually by outside people, what is the best security startegy to use, just plain ServerReportCredentials passing, or something else?
View 1 Replies
Jan 21, 2010
I have an SSRS report that has a Comments field where there's enough text to span multiple rows per record. It renders fine in the ASP.Net ReportViewer control, but when it's exported the formatting can be different. Exporting to Word it looks fantastic. But exporting to Excel and PDF, the row height for each record is never increased beyond the default, so the text just gets truncated. In Excel I can go in and double-click on individual or multiple row heights to fix them, but this is an extra step we don't want.
View 2 Replies
Nov 18, 2010
Any C# Code or any setting in Reportviewer to call SSRS Subreport from ReportViewerThe SSRS Subreport executes properly from report manager.
View 1 Replies
Feb 24, 2010
A project I own was just moved from an older server to a new one, and in the process of moving the web folder, re-deploying the SSRS reports, restoring the database, configuring IIS, etc... I have lost the ability to view the Microsoft Chart Controls that are embedded in the SSRS reports, that are then displayed by a Microsoft.ReportViewer.
I could view them both locally and remotely (via the internet) on the old server. I can view them if I preview the SSRS report in Visual Studio. The report displays fine, only missing all the embedded charts. I can still view them locally through the web browser, just not from the internet.
I tried giving permissions to the ChartImageHandler temp storage folder, but it didn't work.
I'm getting the Javascript error: Error: ClientReport380ec8ca0c294a809e9986c1bef9db1c is undefined
View 4 Replies
Jun 21, 2010
Has anyone successfully implemented forms authentication with SSRS? It seems like a lot of the documentation out there is just wrong or doesn't indicate which version of IIS / SSRS is being used.
View 1 Replies
Jan 19, 2011
my qyery is Select * from UserTable .
i set my parameter as @UserId,checked multivalue check box.
in Available values-from query-i set my value and label field.
default value is null.
when i click the preview tab,multiple UserId with check box appear in drop down list...
when i select any one userid ..i get the result for all the userid list instead i want only the selected userid's information...
View 3 Replies
Dec 22, 2010
I am desinging the report in ssrs 2005.I used table control to display data.I have three columns col1,col2 and col3.Col2 and col3 are grouped on Col1 where as Col1 is monthend_dateMy result should be like this
View 1 Replies
Mar 9, 2011
what are the things to get noticed before moving reports.? What are the common errors that we come across while moving?
View 4 Replies
Sep 17, 2010
I have two parameters :
1. ReportType (with values - Manager, Supervisor, ALL)
2. EnterID (should enter manually)
Normally, the intention of my report is when the user selects ReportType as ALL, they should enter in EnterID as ALL But for some reason, when the user selects ReportType as ALL and he enters the EnterID as value 100 or 200 or some number, the report is showing incorrect results. Now, what I want is When the user selects ReportType as 'ALL' and if he enters anynumber other than ALL, I would like to see a pop up message displaying saying 'Please type ALL'.
View 3 Replies
Sep 14, 2010
I would like to hide a column in matrix using SSRS 2005 but when i use visibility : hidden then it shows white space and if i reduce a width to 0in; but it accepts by default 0.035in something.
i really would like to hide a complete column without any whitespace and all.
View 2 Replies
Jan 9, 2011
i want to write query in run time in SSRS.is it possible??...
View 1 Replies
Aug 12, 2010
Due to a recent hard disk failure, my company issued me Windows 7 (in part for certification testing as we begin to roll it out to the general employee base at the end of the year). As a result, I'm using vwd 2010, where I had been using vwd 2005. The existing site used the reportviewer 2005, but I'm finding it difficult to find information about editing those files in vwd 2010. Can anyone point me to the appropriate place or have some insight as to what must happen in order to manage 2005 reportviewer reports in vwd 2010? I have downloaded and installed the reportviewer 2010 add in. The site is using framework 2.0 even though the web servers are using 3.5 (One of the things I need to do is upgrade the site to 3.5, but I have a support issue to work on first.)
View 3 Replies
Sep 13, 2010
i would like to hide the % of toggle item when image is + then it sum up the % which is incorrect.
Hence i would like to hide the % column when toggle image is + otherwise show the % column value.
i tried something - IIF(TextBox.ToggleState,false,true) or iif(toggle state = 'Collapsed', Parameter A, Parameter B)) in visibility column with expression but it does not seems to work in SSRS 2005.
View 1 Replies
Feb 10, 2010
I am using SSRS 2005 and want to hide specific set of rowsin a matrix when a texts has been toggled. The visibility functiondoes not working as i wanted because it hide/show either set. What i need is show everything and when a text is click show a specific set.
example:
[code]....
View 1 Replies
Mar 11, 2010
I am missing this DLL reference in c:program filesSQL Server90ToolsBinn. I'm assuming that this is because I didn't install the 2005 client. I installed all of the services for 2005, the database instance, reporting services instance, SSAS and SSIS. I installed the 2008 client though, not the 2005 client, and 2008 database instance.So I assume it's because I didn't install the client, but does something else give me this DLL? Another install or a SDK or something?
View 1 Replies
Aug 12, 2010
I have 3 parameters say A,B,C. I want that when I select values in A and B only then C comes alive. I am using cascading parameter in SSRS 2005.
I know that in cascading parameters, one parameters passes a value to other one and it comes alive. But I want that 2 parameters pass the value to a single one.
dont say to use multi select as multi select is used only when we have to multi select from one parameter.
Also one thing how can I use radio buttons in SSRS 2005 and how to hide null checkbox when allowing null values in calender control.
View 1 Replies
Jan 28, 2010
I am new to SQL Server Reporting Services. I am generating Reports VS 2005 Business Intelligence Report Server Project.
Here I got a general QQ when I am generating report.
How can i add custom text if column value is null. I tried to add it by column Expression property.
i,e =IIF(IsNothing(Fields!DOB_YY.Value) , "Null", Fields!DOB_YY.Value)
Here I added custom text as 'NULL'. But its not doing any changes in my pages.
View 12 Replies
Aug 12, 2010
I am using SSRS 2005.
I have a problem when I am exporting my report to Excel.
When exported to excel, I could see the table header on only the first page but not on all the pages. I have also checked the option "Repeat Header rows on New Page", but that didnt work.
View 7 Replies
May 12, 2010
I have a working SQL Server 2005 Express on my PC. Now I want to use Business Intelligence Development Studio so that I can create reports using SSRS. But I am not sure what to do. I assume I have to download this module. But the only things I see when I search is the entire SQL Server 2005 Express. I do not want to do this and wipeout my present databases. Can someone list the steps I need to follow to get this working on my PC?
View 2 Replies
Aug 13, 2010
i have a gridview bound to sql datasource with template fields binding the columns. I have set the Header Style to a css class. I have 3 columns not bound to data as Add, Edit and Delete. When I set the text color to white for the header only the non bound columns go white. The bound columns are BLUE like hyperlink. Any one know a way round this. (If I set the style in the gridview the all columns are white. Want to set in external css file).
[Code]....
View 1 Replies
