How can I use a reportviewer control in an asp net mvc 3 razor view

Question

I m trying to use a reportviewer control  within a razor view  in the mvc 3 framework  The online documentation talks of drag and drop  Any suggestion on how to insert it into the view

User · Answer

I am using ASP NET MVC3 with SSRS 2008 and I couldn t get  Adrian s to work 100  for me when trying to get reports from a remote server   Finally  I found that I needed to change the Page Load method in ViewUserControl1 ascx to look like this   ReportViewer1 ProcessingMode   ProcessingMode Remote  ServerReport serverReport   ReportViewer1 ServerReport  serverReport ReportServerUrl   new Uri  http    lt Server Name gt  reportserver    serverReport ReportPath     My Folder MyReport   serverReport Refresh      I had been missing the ProcessingMode Remote   References   http   msdn microsoft com en-us library aa337091 aspx - ReportViewer

User · Answer

It is possible to get an SSRS report to appear on an MVC page without using iFrames or an aspx page   The bulk of the work is explained here   http   geekswithblogs net stun archive 2010 02 26 executing-reporting-services-web-service-from-asp-net-mvc-using-wcf-add-service-reference aspx  The link explains how to create a web service and MVC action method that will allow you to call the reporting service and render result of the web service as an Excel file  With a small change to the code in the example you can render it as HTML    All you need to do then is use a button to call a javascript function that makes an AJAX call to your MVC action which returns the HTML of the report  When the AJAX call returns with the HTML just replace a div with this HTML   We use AngularJS so my example below is in that format  but it could be any javascript function   scope getReport   function          http           method   POST           url   Report ExportReport           data                                           Name   DateFrom   Value   scope dateFrom                          Name   DateTo   Value   scope dateTo                          Name   LocationsCSV   Value   scope locationCSV                                  success function  serverData                    ReportDiv   html serverData                 And the Action Method - mainly taken from the above link          System Web Mvc HttpPost      public FileContentResult ExportReport  FromBody List lt ReportParameterModel gt  parameters                 byte   output           string extension  mimeType  encoding           string reportName     Reports DummyReport            ReportService Warning   warnings           string   ids        ReportExporter Export               ReportExecutionServiceSoap               new NetworkCredential  username    password    domain                reportName              parameters ToArray                ExportFormat HTML4              out output              out extension              out mimeType              out encoding              out warnings              out ids                       -------------------------------------------------------------            Set HTTP Response Header to show download dialog popup           -------------------------------------------------------------         Response AddHeader  content-disposition   string Format  attachment filename GeneratedExcelFile 0 yyyyMMdd   1    DateTime Today  extension            return new FileContentResult output  mimeType           So the result is that you get to pass parameters to an SSRS reporting server which returns a report which you render as HTML  Everything appears on the one page  This is the best solution I could find

User · Answer

You will not only have to use an asp net page but  If using the Entity Framework or LinqToSql  if using partial classes  move the data into a separate project  the report designer cannot see the classes   Move the reports to another project dll  VS10 has bugs were asp net projects cannot see object datasources in web apps   Then stream the reports from the dll into your mvc projects aspx page   This applies for mvc and webform projects   Using sql reports in the local mode is not a pleasent development experience   Also watch your webserver memory if exporting large reports    The reportviewer export is very poorly designed

User · Answer

This is a simple task  You can follow the following steps    Create a folder in your solution and name it Reports  Add an ASP Net web form and name it ReportView aspx Create a Class ReportData and add it to the Reports folder  Add the  following code to the Class   public class ReportData           public ReportData                     this ReportParameters   new List lt Parameter gt               this DataParameters   new List lt Parameter gt                  public bool IsLocal   get  set        public string ReportName   get  set        public List lt Parameter gt  ReportParameters   get  set        public List lt Parameter gt  DataParameters   get  set       public class Parameter           public string ParameterName   get  set          public string Value   get  set         Add another Class and name it ReportBasePage cs  Add the following code in this Class   public class ReportBasePage   System Web UI Page       protected ReportData ReportDataObj   get  set         protected override void OnInit EventArgs e                base OnInit e           if  HttpContext Current    null              if  HttpContext Current Session  ReportData      null                                ReportDataObj   HttpContext Current Session  ReportData   as ReportData                  return                        ReportDataObj   new ReportData            CaptureRouteData Page Request               private void CaptureRouteData HttpRequest request                var mode    request QueryString  rptmode         Trim            ReportDataObj IsLocal   mode     local    true   false          ReportDataObj ReportName   request QueryString  reportname                 string dquerystr   request QueryString  parameters                 if   String IsNullOrEmpty dquerystr Trim                           var param1   dquerystr Split                   foreach  string pm in param1                                var rp   new Parameter                    var kd   pm Split                       if  kd 0  Substring 0  2      rp                                         rp ParameterName   kd 0  Replace  rp                            if  kd Length  gt  1  rp Value   kd 1                       ReportDataObj ReportParameters Add rp                                     else if  kd 0  Substring 0  2      dp                                         rp ParameterName   kd 0  Replace  dp                            if  kd Length  gt  1  rp Value   kd 1                       ReportDataObj DataParameters Add rp                                                      Add ScriptManager to the ReportView aspx page  Now add a Report Viewer to the page  In report viewer set the property AsyncRendering  false   The code is given below                   lt rsweb ReportViewer ID  ReportViewerRSFReports  runat  server  AsyncRendering  false          Width  1271px  Height  1000px   gt       lt  rsweb ReportViewer gt   Add two NameSpace in ReportView aspx cs  using Microsoft Reporting WebForms  using System IO   Change the System Web UI Page to ReportBasePage  Just replace your code using the following   public partial class ReportView   ReportBasePage       protected void Page Load object sender  EventArgs e                if   IsPostBack                        RenderReportModels this ReportDataObj                        private void RenderReportModels ReportData reportData                   This is the Data Access Layer from which a method is called to fill data to the list          RASolarERPData dal   new RASolarERPData            List lt ClosingInventoryValuation gt  objClosingInventory   new List lt ClosingInventoryValuation gt                 Reset report properties          ReportViewerRSFReports Height   Unit Parse  100             ReportViewerRSFReports Width   Unit Parse  100             ReportViewerRSFReports CssClass    table               Clear out any previous datasources          this ReportViewerRSFReports LocalReport DataSources Clear                Set report mode for local processing          ReportViewerRSFReports ProcessingMode   ProcessingMode Local              Validate report source          var rptPath   Server MapPath     Report     reportData ReportName    rdlc                 E  RSFERP SourceCode RASolarERP RASolarERP Reports Report     reportData ReportName     rdlc             Server MapPath     Report ClosingInventory rdlc             if   File Exists rptPath               return              Set report path          this ReportViewerRSFReports LocalReport ReportPath   rptPath              Set report parameters          var rpPms   ReportViewerRSFReports LocalReport GetParameters            foreach  var rpm in rpPms                        var p   reportData ReportParameters SingleOrDefault o   gt  o ParameterName ToLower      rpm Name ToLower                 if  p    null                                ReportParameter rp   new ReportParameter rpm Name  p Value                   ReportViewerRSFReports LocalReport SetParameters rp                                      Set data paramater for report SP execution         objClosingInventory   dal ClosingInventoryReport this ReportDataObj DataParameters 0  Value               Load the dataSource          var dsmems   ReportViewerRSFReports LocalReport GetDataSourceNames            ReportViewerRSFReports LocalReport DataSources Add new ReportDataSource dsmems 0   objClosingInventory                Refresh the ReportViewer          ReportViewerRSFReports LocalReport Refresh             Add a Folder to the Reports Folder and name it Report  Now add a RDLC report to the Reports Report folder and name it ClosingInventory rdlc   Now add a Controller and name it ReportController  In the controller add the following action method   public ActionResult ReportViewer                                 ViewData  reportUrl         Reports View local ClosingInventory             return View           Add a view page click on the ReportViewer Controller  Name the view page ReportViewer cshtml  Add the following code to the view page    using  Html BeginForm  Login                Html DropDownList  ddlYearMonthFormat   new SelectList ViewBag YearMonthFormat   YearMonthValue     YearMonthName    new    class    DropDown      Stock In Transit   Html TextBox  txtStockInTransit       new    class    LogInTextBox       lt input type  submit  onclick  return ReportValidationCheck     name  ShowReport                   value  Show Report    gt      Add an Iframe  Set the property of the Iframe as follows  frameborder  0   width  1000   height  1000   style  overflow hidden   scrolling  no   Add Following JavaScript to the viewer   function ReportValidationCheck          var url       hdUrl   val        var yearmonth       ddlYearMonthFormat   val              var stockInTransit       txtStockInTransit   val        if  stockInTransit                  stockInTransit   0             if  yearmonth     0             alert  Please Select Month Correctly               else              url   url    dpSpYearMonth     yearmonth     rpYearMonth     yearmonth     rpStockInTransit     stockInTransit           url       Reports ReportView aspx rptmode local amp reportname ClosingInventory amp parameters dpSpYearMonth     yearmonth     rpYearMonth     yearmonth     rpStockInTransit     stockInTransit           var myframe   document getElementById  ifrmReportViewer            if  myframe     null                if  myframe src                    myframe src   url                            else if  myframe contentWindow     null  amp  amp  myframe contentWindow location     null                    myframe contentWindow location   url                            else   myframe setAttribute  src   url                          return false     Web config file add the following key to the appSettings section  add key  UnobtrusiveJavaScriptEnabled  value  true   In system web handlers Section add the following key  add verb     path  Reserved ReportViewerWebControl axd  type    Microsoft Reporting WebForms HttpHandler  Microsoft ReportViewer WebForms  Version 10 0 0 0  Culture neutral  PublicKeyToken b03f5f7f11d50a3a   Change your data source to your own  This solution is very simple and I think every one will enjoy it

User · Answer

The following solution works only for single page reports  Refer to comments for more details   ReportViewer is a server control and thus can not be used within a razor view  However you can add a ASPX view page  view user control or traditional web form that containing a ReportViewer into the application   You will need to ensure that you have added the relevant handler into your web config    If you use a ASPX view page or view user control you will need to set  AsyncRendering to false to get the report to display properly   Update   Added more sample code  Note there are no meaningful changes required in Global asax   Web Config  Mine ended up as follows    lt  xml version  1 0   gt   lt  --   For more information on how to configure your ASP NET application  please visit   http   go microsoft com fwlink  LinkId 152368   -- gt    lt configuration gt     lt appSettings gt       lt add key  webpages Version  value  1 0 0 0   gt       lt add key  ClientValidationEnabled  value  true   gt       lt add key  UnobtrusiveJavaScriptEnabled  value  true   gt     lt  appSettings gt      lt system web gt       lt compilation debug  true  targetFramework  4 0  gt         lt assemblies gt           lt add assembly  System Web Abstractions  Version 4 0 0 0  Culture neutral  PublicKeyToken 31BF3856AD364E35    gt           lt add assembly  System Web Helpers  Version 1 0 0 0  Culture neutral  PublicKeyToken 31BF3856AD364E35    gt           lt add assembly  System Web Routing  Version 4 0 0 0  Culture neutral  PublicKeyToken 31BF3856AD364E35    gt           lt add assembly  System Web Mvc  Version 3 0 0 0  Culture neutral  PublicKeyToken 31BF3856AD364E35    gt           lt add assembly  System Web WebPages  Version 1 0 0 0  Culture neutral  PublicKeyToken 31BF3856AD364E35    gt           lt add assembly  Microsoft ReportViewer WebForms  Version 10 0 0 0  Culture neutral  PublicKeyToken B03F5F7F11D50A3A   gt           lt add assembly  Microsoft ReportViewer Common  Version 10 0 0 0  Culture neutral  PublicKeyToken B03F5F7F11D50A3A   gt         lt  assemblies gt       lt  compilation gt        lt authentication mode  Forms  gt         lt forms loginUrl    Account LogOn  timeout  2880    gt       lt  authentication gt        lt pages gt         lt namespaces gt           lt add namespace  System Web Helpers    gt           lt add namespace  System Web Mvc    gt           lt add namespace  System Web Mvc Ajax    gt           lt add namespace  System Web Mvc Html    gt           lt add namespace  System Web Routing    gt           lt add namespace  System Web WebPages   gt         lt  namespaces gt       lt  pages gt     lt  system web gt      lt system webServer gt       lt validation validateIntegratedModeConfiguration  false   gt       lt modules runAllManagedModulesForAllRequests  true   gt       lt handlers gt         lt 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    gt       lt  handlers gt     lt  system webServer gt      lt runtime gt       lt assemblyBinding xmlns  urn schemas-microsoft-com asm v1  gt         lt dependentAssembly gt           lt assemblyIdentity name  System Web Mvc  publicKeyToken  31bf3856ad364e35    gt           lt bindingRedirect oldVersion  1 0 0 0-2 0 0 0  newVersion  3 0 0 0    gt         lt  dependentAssembly gt       lt  assemblyBinding gt     lt  runtime gt   lt  configuration gt    Controller  The controller actions are very simple   As a bonus the File   action returns the output of  TestReport rdlc  as a PDF file   using System Web Mvc  using Microsoft Reporting WebForms        public class PDFController   Controller       public ActionResult Index                 return View               public FileResult File                 ReportViewer rv   new Microsoft Reporting WebForms ReportViewer            rv ProcessingMode   ProcessingMode Local          rv LocalReport ReportPath   Server MapPath    Reports TestReport rdlc            rv LocalReport Refresh             byte   streamBytes   null          string mimeType               string encoding               string filenameExtension               string   streamids   null          Warning   warnings   null           streamBytes   rv LocalReport Render  PDF   null  out mimeType  out encoding  out filenameExtension  out streamids  out warnings            return File streamBytes  mimeType   TestReport pdf               public ActionResult ASPXView                 return View               public ActionResult ASPXUserControl                 return View              ASPXView apsx  The ASPXView is as follows    lt    Page Language  C   Inherits  System Web Mvc ViewPage lt dynamic gt     gt   lt    Register Assembly  Microsoft ReportViewer WebForms  Version 10 0 0 0  Culture neutral  PublicKeyToken b03f5f7f11d50a3a      Namespace  Microsoft Reporting WebForms  TagPrefix  rsweb    gt    lt  DOCTYPE html gt    lt html gt   lt head runat  server  gt       lt title gt ASPXView lt  title gt   lt  head gt   lt body gt       lt div gt           lt script runat  server  gt              private void Page Load object sender  System EventArgs e                                ReportViewer1 LocalReport ReportPath   Server MapPath    Reports TestReport rdlc                    ReportViewer1 LocalReport Refresh                           lt  script gt           lt form id  Form1  runat  server  gt           lt asp ScriptManager ID  ScriptManager1  runat  server  gt                     lt  asp ScriptManager gt           lt rsweb reportviewer id  ReportViewer1  runat  server  height  500  width  500  AsyncRendering  false  gt  lt  rsweb reportviewer gt           lt  form gt               lt  div gt   lt  body gt   lt  html gt    ViewUserControl1 ascx  The ASPX user control looks like    lt    Control Language  C   Inherits  System Web Mvc ViewUserControl    gt   lt    Register Assembly  Microsoft ReportViewer WebForms  Version 10 0 0 0  Culture neutral  PublicKeyToken b03f5f7f11d50a3a      Namespace  Microsoft Reporting WebForms  TagPrefix  rsweb    gt   lt script runat  server  gt    private void Page Load object sender  System EventArgs e            ReportViewer1 LocalReport ReportPath   Server MapPath    Reports TestReport rdlc          ReportViewer1 LocalReport Refresh         lt  script gt   lt form id  Form1  runat  server  gt   lt asp ScriptManager ID  ScriptManager1  runat  server  gt  lt  asp ScriptManager gt   lt rsweb ReportViewer ID  ReportViewer1  runat  server  AsyncRendering  false  gt  lt  rsweb ReportViewer gt   lt  form gt    ASPXUserControl cshtml  Razor view  Requires ViewUserControl1 ascx          ViewBag Title    ASPXUserControl       Layout      Views Shared  Layout cshtml      lt h2 gt ASPXUserControl lt  h2 gt   Html Partial  ViewUserControl1     References  http   blogs msdn com b sajoshi archive 2010 06 16 asp-net-mvc-handling-ssrs-reports-with-reportviewer-part-i aspx  bind report to reportviewer in web mvc2

User · Answer

There s a MvcReportViewer helper in NuGet    http   www nuget org packages MvcReportViewer   And this is the details   https   github com ilich MvcReportViewer  I have using this  It works great

User · Answer

the documentations refers to an ASP NET application  You can try and have a look at my answer here  I have an example attached to my reply  Another example for ASP NET MVC3 can be found here

User · Answer

Here is the complete solution for directly integrating a report-viewer control  as well as any asp net server side control  in an MVC  aspx view  which will also work on a report with multiple pages  unlike Adrian Toman s answer  and with AsyncRendering set to true   based on  Pro ASP NET MVC Framework  by Steve Sanderson    What one needs to do is basically    Add a form with runat    server     Add the control   for report-viewer controls it can also sometimes work even with AsyncRendering  True  but not always  so check in your specific case  Add server side scripting by using script tags with runat    server  Override the Page Init event with the code shown below  to enable the use of PostBack and Viewstate   Here is a demonstration    lt form ID  form1  runat  server  gt       lt rsweb ReportViewer ID  ReportViewer1  runat  server    gt   lt  form gt   lt script runat  server  gt      protected void Page Init object sender  EventArgs e                Context Handler   Page              Other code needed for the report viewer here          lt  script gt    It is of course recommended to fully utilize the MVC approach  by preparing all needed data in the controller  and then passing it to the view via the ViewModel           This will allow reuse of the View   However this is only said for data this is needed for every post back  or even if they are required only for initialization if it is not data intensive  and the data also has not to be dependent on the PostBack and ViewState values   However even data intensive can sometimes be encapsulated into a lambda expression and then passed to the view to be called there   A couple of notes though    By doing this the view essentially turns into a web form with all it s drawbacks   i e  Postbacks  and the possibility of non Asp NET controls getting overriden  The hack of overriding Page Init is undocumented  and it is subject to change at any time

[asp.net-mvc-3] How can I use a reportviewer control in an asp.net mvc 3 razor view?

Examples related to asp.net-mvc-3

Examples related to razor

Examples related to reportviewer