How To Display SSRS Report In ASP.NET MVC Web Application

Hello is this procedure applicable to asp.net core MVC?

HI Hussain, any possible way to list all SSRS reports in one page dynamically and when user click on particular report it's open in report viewer.

Any suggestions on using SSRS in .Net Core?

Hi Hussain, thank you for the nice article. Is this approach will work with .Net Core 3.1 or do you have any idea how can we display SSRS reports in ASP.Net Core MVC 3.1?

Hi. Thanks for this. Works like a charm in dev environment. When I deployed it to a remote server, it is prompting me for a user id and password. How can you programmatically pass the credentials to the report server? Thanks again.

Hi Hussain, thank you for this usefull article. I have a question : how to localize the reportviewer interface ?

Hello Hussain, Idk why u created ReportTemplate.aspx and its cs code, if u just iframe in its view with url that u retrieved from controller. I mean everything will work good if u delete this if (!IsPostBack) { try { String reportFolder = System.Configuration.ConfigurationManager.AppSettings["SSRSReportsFolder"].ToString(); rvSiteMapping.Height = Unit.Pixel(Convert.ToInt32(Request["Height"]) - 58); rvSiteMapping.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote; rvSiteMapping.ServerReport.ReportServerUrl = new Uri("SSRS URL"); // Add the Reporting Server URL rvSiteMapping.ServerReport.ReportPath = String.Format("/{0}/{1}", reportFolder, Request["ReportName"].ToString()); rvSiteMapping.ServerReport.Refresh(); } catch (Exception ex) { } }

Hello Hussain,I am looking for creating .rdlc file dynamically, means I want to display report in report viewer control from direct datasource/list in MVC using C#. I do not want to create .rdlc file and .xsd file manually. Is there anyway then help me. Thanks in Advance

Hello Hussain, I have gone through your post and it is really very informative. I have configured SSRS in my project but I am facing one issue. Afterwards, I have downloaded your source code and ran it, and I got the same error "Your browser does not support scripts or has been configured not to allow scripts.". I have tried adding local report server url in Trusted sites but no luck. Can you please look into it and suggest me what should I do? Here is the error in detail : <noscript> Your browser does not support scripts or has been configured not to allow scripts. </noscript><span id="rvSiteMapping_ReportViewer"><div id="rvSiteMapping" onclick="if ($get('rvSiteMapping_ctl04') != null && $get('rvSiteMapping_ctl04').control != null) $get('rvSiteMapping_ctl04').control.HideActiveDropDown();" onactivate="if ($get('rvSiteMapping_ctl04') != null && $get('rvSiteMapping_ctl04').control != null) $get('rvSiteMapping_ctl04').control.HideActiveDropDown();" style="height:592px;width:99.9%;"> <div id="rvSiteMapping_HttpHandlerMissingErrorMessage" style="border-color:Red;border-width:2px;border-style:Solid;padding:10px;display:none;overflow:auto;font-size:.85em;"> <h2> Report Viewer Configuration Error </h2><p>The Report Viewer Web Control HTTP Handler has not been registered in the application's web.config file. Add <add verb="*" path="Reserved.ReportViewerWebControl.axd" type = "Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" /> to the system.web/httpHandlers section of the web.config file, or add <add name="ReportViewerWebControlHandler" preCondition="integratedMode" verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" /> to the system.webServer/handlers section for Internet Information Services 7 or later.</p> </div><span id="rvSiteMapping_ctl03"><input type="hidden" name="rvSiteMapping$ctl03$ctl00" id="rvSiteMapping_ctl03_ctl00" /><input type="hidden" name="rvSiteMapping$ctl03$ctl01" id="rvSiteMapping_ctl03_ctl01" /></span><input type="hidden" name="rvSiteMapping$ctl10" id="rvSiteMapping_ctl10" /><input type="hidden" name="rvSiteMapping$ctl11" id="rvSiteMapping_ctl11" /><div id="rvSiteMapping_AsyncWait" style="background-color:White;opacity:0.7;position:absolute;display:none;filter:alpha(opacity=70);"> </div><div id="rvSiteMapping_AsyncWait_Wait" style="cursor:wait;background-color:#ECE9D8;padding:15px;border:1px solid black;display:none;position:absolute;"> <table height="100%"> <tr> <td width="32px" height="32px"><img src="/Reserved.ReportViewerWebControl.axd?OpType=Resource&Version=11.0.2802.16&Name=Microsoft.Reporting.WebForms.Icons.SpinningWheel.gif" alt="Loading..." style="height:32px;width:32px;" /></td><td style="vertical-align:middle;text-align:center;"><span style="font-family:Verdana;font-size:14pt;">Loading...</span><div style="margin-top:3px;"> <a href="javascript:$get('rvSiteMapping_AsyncWait').control._cancelCurrentPostback();" style="font-family:Verdana;font-size:8pt;color:#3366CC;">Cancel</a> </div></td> </tr> </table> </div><input type="hidden" name="rvSiteMapping$AsyncWait$HiddenCancelField" id="rvSiteMapping_AsyncWait_HiddenCancelField" value="False" /><table cellpadding="0" cellspacing="0" id="rvSiteMapping_fixedTable" style="table-layout:fixed;width:100%;height:100%;"> <tr> <td style="display:none;width:25%;"></td><td style="display:none;width:6px;"></td><td style="width:100%;"></td> </tr><tr id="ParametersRowrvSiteMapping" style="display:none;"> <td colspan="3"></td> </tr><tr style="height:6px;font-size:2pt;display:none;"> <td colspan="3" style="padding:0px;margin:0px;text-align:center;background-color:#ECE9D8;"><div id="rvSiteMapping_ToggleParam"> <input type="image" name="rvSiteMapping$ToggleParam$img" id="rvSiteMapping_ToggleParam_img" title="Show / Hide Parameters" src="/Reserved.ReportViewerWebControl.axd?OpType=Resource&Version=11.0.2802.16&Name=Microsoft.Reporting.WebForms.Icons.SplitterHorizCollapse.png" alt="Show / Hide Parameters" align="middle" onclick="void(0);" style="cursor:pointer;" /><input type="hidden" name="rvSiteMapping$ToggleParam$store" id="rvSiteMapping_ToggleParam_store" /><input type="hidden" name="rvSiteMapping$ToggleParam$collapse" id="rvSiteMapping_ToggleParam_collapse" value="false" /> </div></td> </tr><tr style="display:none;"> </tr><tr> <td style="vertical-align:top;width:25%;height:100%;display:none;"><div style="width:100%;height:100%;"> <span id="rvSiteMapping_DocMap"><div id="rvSiteMapping_ctl08" style="display:none;"> <input type="hidden" name="rvSiteMapping$ctl08$ClientClickedId" id="rvSiteMapping_ctl08_ClientClickedId" /> </div></span> </div></td><td style="display:none;width:4px;padding:0px;margin:0px;height:100%;vertical-align:middle;background-color:#ECE9D8;"><div id="rvSiteMapping_ctl07"> <input type="image" name="rvSiteMapping$ctl07$img" id="rvSiteMapping_ctl07_img" title="Show / Hide Document Map" src="/Reserved.ReportViewerWebControl.axd?OpType=Resource&Version=11.0.2802.16&Name=Microsoft.Reporting.WebForms.Icons.SplitterVertCollapse.png" alt="Show / Hide Document Map" align="top" onclick="void(0);" style="cursor:pointer;" /><input type="hidden" name="rvSiteMapping$ctl07$store" id="rvSiteMapping_ctl07_store" /><input type="hidden" name="rvSiteMapping$ctl07$collapse" id="rvSiteMapping_ctl07_collapse" value="false" /> </div></td><td style="height:100%;vertical-align:top;"><div id="rvSiteMapping_ctl09" style="height:100%;width:100%;overflow:auto;position:relative;"> <div id="VisibleReportContentrvSiteMapping_ctl09" style="height:100%;display:none;"> </div><div id="rvSiteMapping_ctl09_ReportArea"> <div NewContentType="Microsoft.Reporting.WebFormsClient.ReportAreaContent.None" ForNonReportContentArea="false" id="rvSiteMapping_ctl09_VisibilityState" style="visibility:none;"> <input type="hidden" name="rvSiteMapping$ctl09$VisibilityState$ctl00" value="None" /> </div><input type="hidden" name="rvSiteMapping$ctl09$ScrollPosition" id="rvSiteMapping_ctl09_ScrollPosition" /><span id="rvSiteMapping_ctl09_Reserved_AsyncLoadTarget"></span><div id="rvSiteMapping_ctl09_ReportControl" style="display:none;"> <span></span><input type="hidden" name="rvSiteMapping$ctl09$ReportControl$ctl02" /><input type="hidden" name="rvSiteMapping$ctl09$ReportControl$ctl03" /><input type="hidden" name="rvSiteMapping$ctl09$ReportControl$ctl04" id="rvSiteMapping_ctl09_ReportControl_ctl04" value="100" /> </div><div id="rvSiteMapping_ctl09_NonReportContent" style="height:100%;width:100%;"> </div> </div> </div></td> </tr> </table> </div></span> </div>

HI Dan, I don't know if you have already tried, however, in the report server uri, you need to pass url as "http://servername/reportserver" If you do not pass reportserver after your server name, you will get an error. To pass parameters, you can user the following: List<ReportParameter> pList = new new List<ReportParameter>(); pList.Add(new ReportParameter("para1", paraivalue); ReportViewer1.ServerReport.SetParameters(pList); Hope this helps

Hi Hussain. I used your example to display reports in my ASP.NET MVC web application. Now I need to pass two parameters and despite many attempts to figure it out, my report just does not accept the two values I appended to the URL. Do you have another version of this post to display how I can pass parameters to my parameterized report?

HI Hussain, I followed your code, however, I am getting an error, both from my local machine and when deployed to the web server, as follows: Unable to connect to the remote serverA connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 35.8.208.11:443 I can ping the SSRS server from my local machine. I tried several forums, but did not get any solution. Can you please let me know what the issue could be? Thanks

Hi, I am getting below error while trying to incorporating the report form the url. But the same URL which was build rvSiteMapping.ServerReport. is working normal browser by directly hitting through the address bar. But through my application , it is generating below exception. Please suggest me the changes. I am very new to this concept. The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" > <HTML> <HEAD lang="en-US"> <META HTTP-EQUIV="X-UA-Compatible" CONTENT="IE=5"> <script language="JScript" type="text/Javascript" src="/Reports/js/ReportingServices.js"></script> <TITLE>Error - Report Manager</TITLE> <link href="/Reports/styles/ReportingServices.css"type="text/css" rel="stylesheet"> <META Name="Report Server" CONTENT="http://uspgh-cmfrps-p1:80/ReportServer"> <META Name="HTTP Status" CONTENT="400"> <META Name="ProductLocaleID" CONTENT=""> <META Name="CountryLocaleID" CONTENT=""> </HEAD> <BODY style="margin:0px;" class="msrs-normal" onload=""><form name="ui_form" method="POST" action="Error.aspx" id="ui_form" enctype="multipart/form-data"> <div> <input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUENTM4MQ8WAh4RUGFnZVZpZXdTdGF0ZVRpbWUoKVlTeXN0ZW0uSW50NjQsIG1zY29ybGliLCBWZXJzaW9uPTIuMC4wLjAsIEN1bHR1cmU9bmV1dHJhbCwgUHVibGljS2V5VG9rZW49Yjc3YTVjNTYxOTM0ZTA4ORI2MzY2OTM0OTM4ODI3NDA1MzUWAgIBD2QWAgIDD2QWAmYPZBYCZg9kFgJmD2QWBmYPFgIeB1Zpc2libGVoZAIBD2QWAmYPZBYCZg9kFgJmDxYIHgZ2YWxpZ24FA3RvcB4GaGVpZ2h0BQIzMB4HY29sc3BhbgUBNB4FY2xhc3MFFG1zcnMtdmFsaWRhdGlvbmVycm9yZAICD2QWAmYPZBYCZg9kFgJmD2QWAgIBD2QWAmYPZBYCAgEPZBYCZg8WAh4JaW5uZXJodG1sBR1TUUwgU2VydmVyIFJlcG9ydGluZyBTZXJ2aWNlc2RkygvBmvMjFEGkRq878VyIX6jfu5w=" /> </div> <div> <input type="hidden" name="__VIEWSTATEGENERATOR" id="__VIEWSTATEGENERATOR" value="7518703D" /> </div><span><noscript><table width="100%" class="msrs-normal"> <tr> <td valign="top" height="30" colspan="4" class="msrs-validationerror"><img src="/Reports/images/blank.gif" height="1" width="24" border="0" /><img src="/Reports/images/line_err1.gif" height="16" width="16" alt="Error" /><img src="/Reports/images/blank.gif" height="1" width="12" border="0" />This page might not function correctly because either your browser does not support scripts or active scripting is disabled.</td> </tr> </table> </noscript><table width="100%" class="msrs-normal" cellpadding="0" cellspacing="0" height="100%"> <tr> <td valign="top"><div> <table class="msrs-topBreadcrumb" cellpadding="0" cellspacing="0" border="0" width="100%"> <tr> <td></td> <td align="right"><span><a href="/Reports/Pages/Folder.aspx">Home</a> | <a href="/Reports/Pages/Subscriptions.aspx">My Subscriptions</a> | <a href="/Reports/Pages/Settings.aspx">Site Settings</a> | <a href="http://go.microsoft.com/fwlink/?LinkID=301642" target="MicrosoftReportingServicesHelp">Help</a></span></td> </tr> </table> <table class="msrs-header" cellpadding="0" cellspacing="0" border="0" width="100%"> <tr> <td class="msrs-logo" width="36"><img src="/Reports/images/error_32x.gif" alt="Error" style="height:32px;width:32px;border-width:0px;" /></td> <td><P class="msrs-site_title">SQL Server Reporting Services</P><P class="msrs-page_title">Error</P></td> <td class="msrs-searchContainer" align="right" valign="bottom"></td> </tr> </table> </div></td> </tr> <tr height="100%"> <td valign="top" colspan="3"><table width="100%" class="msrs-contentFrame" cellpadding="0" cellspacing="0" height="100%"> <tr> <td valign="top" height="100%"><span><span><table width="100%" class="msrs-normal" cellpadding="0" cellspacing="0"> <tr class="msrs-toolbar_top" height="6"> <td valign="top"></td> </tr> <tr class="msrs-tool"> <td valign="top"><table width="100%" cellpadding="0" cellspacing="0"> <tr> <td valign="top" width="5"><img src="/Reports/images/blank.gif" height="0" width="5" /></td> <td valign="top" width="3"><img src="/Reports/images/blank.gif" height="0" width="3" /></td> <td width="100%"></td> <td valign="top"> </td> </tr> </table> </td> </tr> <tr class="msrs-toolbar_bottom" height="6"> <td valign="top"></td> </tr> <tr> <td valign="top"><img src="/Reports/images/blank.gif" height="20" width="1" border="0" /></td> </tr> </table> </span><table width="100%" class="msrs-normalwithmargin" cellpadding="0" cellspacing="0"> <tr> <td valign="top" class="msrs-normal"><span><table width="100%" class="msrs-normal" cellpadding="0" cellspacing="0"> <tr> <td valign="top" colspan="2" class="msrs-normal">The item '/RSD Reporting/Initiative Reporting/Savings Report/SavingsReport/ReportExecution2005.asmx' cannot be found. (rsItemNotFound) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsItemNotFound&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=12.0.2430.0" target="_blank">Get Online Help</a></td> </tr> </table> </span></td> </tr> <tr> <td valign="top"><img src="/Reports/images/blank.gif" height="8" width="1" border="0" /></td> </tr> <tr> <td valign="top"><img src="/Reports/images/blank.gif" height="8" width="1" border="0" /></td> </tr> <tr> <td valign="top"><a href="/Reports/Pages/Folder.aspx">Home</a></td> </tr> </table> </span></td> </tr> </table> </td> </tr> </table> </span></form></BODY></HTML> --.

Hi Hussain, I would like to do the same what you did here, but I also need to bind my parameter list from database directly on UI, and those parameter should association with my report at run time. Is there way to do this ?

Is there any way we can move the ReportViewerWebForm.aspx file out of the root directory? Into a subdirectory?

I have done this thing from another method another problem here .. the requirement is .. Basically i am populating the menu dynamically from the data base "through webform " after i am clicking the menu item selected report will open this thing done .. but "i want to show on the header TITLE of the report " after displaying report i also want to show the menu upside the <iframe> i am searching alot but not getting the answer

I have multiple reports on report server and with different reports with different parameter how could i integrate this in my mvc project ??

One Small suggestion to all the Reader and those interested in downloading the code. You can download the whole project from visual studio as well. Following are the steps. 1. Open visual studio. 2. Click on New Project - New project window will open. 3. on the Left hand side click on online. Under Online Select Samples. 4. on the right side - Search for my name or SSRS and you the sample project listed . 5. select the project and click OK, with in minutes the project will opened in solution Explorer.

Hi! This is good article. I have SSRS report on report server that requests user and password to show report. So, when I do this it asks for login. How can I send username and password as authentication credentials? I've seen your comment below regarding Authorize action filter, but it just allows specific users to have access to view report. It still asks for login.

If we use ReportViewerForMvc package then i believe aspx page is not required.

Thanks Man, this works great and gave me a hope on my new project.

I'm not getting calendar icon, please suggest.

The example works perfectly! Thank youHow could a user / password pass to do an auto login?(the url of the report is protected with basic authentication of windows)

Sorry, It's working, Thanks

Could not load file or assembly 'Microsoft.ReportViewer.Common, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

Solution is not working getting error

Funciona igual para SSRS Report 20016?

Thanks a lot. It helped me in my Project

Good one