blocks|key|881261|text|不，不是在MVC视图中。但是你可以在你的MVC站点中创建一个包含服务器控件的web窗体页。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|881262|嗯，我只是在谷歌上搜索"mix+asp.net+mvc+and+web+forms“来找一些例子，谷歌质疑我是否是人:)|881263|无论如何，这里有一个链接-+http://www.packtpub.com/article/mixing-asp.net-webforms-and-asp.net-mvc+-有几个。出于同样的原因，我在MVC站点中也这样做了--报表控件。|offset|length|881264|entityMap|0|LINK|mutability|MUTABLE|url|http://www.packtpub.com/article/mixing-asp.net-webforms-and-asp.net-mvc^0|0|0|E|1Z|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@$F|S|G|T|1|U]]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

No, not in a MVC view. But you can have a web forms pages which have server controls in them mixed in with your MVC site.

Hmm, just googled "mix asp.net mvc and web forms" to find some examples, and google questioned whether I'm human or not :)

Anyway, here's a link - <a href="http://www.packtpub.com/article/mixing-asp.net-webforms-and-asp.net-mvc" rel="noreferrer">http://www.packtpub.com/article/mixing-asp.net-webforms-and-asp.net-mvc</a> - there's a few out there. I've also done this in a MVC site for the same reason - the report control.

blocks|key|1096385|text|现在有了一个MvcReportViewer帮助器。我们可以从NuGet那里得到它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1096386|Project+Site+on+GitHub|offset|length|1096387|NuGet+Package|1096388|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/ilich/MvcReportViewer|1|https://www.nuget.org/packages/MvcReportViewer^0|0|0|M|0|0|0|D|1|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@$D|T|E|U|1|V]]|A|$]]|$1|F|3|G|5|6|7|W|8|@]|9|@$D|X|E|Y|1|Z]]|A|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]|P|$5|K|L|M|A|$N|Q]]]]

Now there's a MvcReportViewer helper. We can get it from NuGet.

<a href="https://github.com/ilich/MvcReportViewer">Project Site on GitHub</a>

<a href="https://www.nuget.org/packages/MvcReportViewer">NuGet Package</a>

blocks|key|1096255|text|这有点简单，需要一些修改才能将一些像样的东西传递给MVC中的视图。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1096256|public+ActionResult+Index()
{
++++/*Credentials+of+a+user+that+has+access+to+SSRS*/
++++string+userid+=+"UserId";
++++string+password+=+"MyPassword";
++++string+domain+=+"MyDomain";

++++string+reportURL="http://ServerName/ReportServer?/ReportsFolder/ReportName&Parameter=UserName&rs:Command=Render&rs:Format=PDF";

++++NetworkCredential+nwc+=+new+NetworkCredential(userid,+password,+domain);

++++WebClient+client+=+new+WebClient();
++++client.Credentials+=+nwc;

++++Byte[]+pageData+=+client.DownloadData(reportURL);

++++Response.ContentType+=+"application/pdf";
++++Response.AddHeader("Content-Disposition",+"attachment;+filename="+%2B+DateTime.Now);
++++Response.BinaryWrite(pageData);
++++Response.Flush();
++++Response.End();

++++//return+View();
++++}|code-block|syntax|javascript|1096257|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This is a bit simple and will require a bit of fixing to pass something decent to a view in MVC 

<pre><code>public ActionResult Index()
{
 /*Credentials of a user that has access to SSRS*/
 string userid = "UserId";
 string password = "MyPassword";
 string domain = "MyDomain";

 string reportURL="http://ServerName/ReportServer?/ReportsFolder/ReportName&amp;Parameter=UserName&amp;rs:Command=Render&amp;rs:Format=PDF";

 NetworkCredential nwc = new NetworkCredential(userid, password, domain);

 WebClient client = new WebClient();
 client.Credentials = nwc;

 Byte[] pageData = client.DownloadData(reportURL);

 Response.ContentType = "application/pdf";
 Response.AddHeader("Content-Disposition", "attachment; filename=" + DateTime.Now);
 Response.BinaryWrite(pageData);
 Response.Flush();
 Response.End();

 //return View();
 }
</code></pre>

blocks|key|1096164|text|一个简单的解决方案是向MVC视图添加一个iframe，该视图可从报告服务web服务中打开所需的报告。iframe将与来自报告服务的组件一起完全运行。如果您想要将组件移出到MVC视图中，则iframe中用于url的参数也可以动态控制(例如，使用ajax)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1096165|尽管此方法有效，但您仍需要登录到web报告服务(+iframe将打开一个登录对话框)。对于IE，这是“自动”完成的，通过使用您的windows登录凭据。|1096166|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

A simple solution is to add an iframe to your MVC view that opens the report you want from the reporting services web service. The iframe will be fully operational with the components from reporting services. The parameters used for the url in the iframe can also be controlled dynamically (e.g. with ajax) if you want to move the components out into your MVC view.

Although this works, you will still have to sign in to the web reporting service (the iframe will open a logon dialog). For IE this is "automagically" done though using your windows logon credentials.

blocks|key|1096563|text|您可以使用ReportViewerForMvc在MVC中查看报告，方法是使用Nuget进行安装|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1096564|Install-Package+Microsoft.Report.Viewer+-Version+11.0.0

Install-Package+Microsoft.ReportViewer.Runtime.WebForms+-Version+12.0.2402.15

Install-Package+ReportViewerForMvc|code-block|syntax|javascript|1096565|如上所示，安装了ReportViewer和其他所需的Nuget包后，在Visual+Studio项目中添加一个新的Report.rdlc|1096566|​|1096567|📷|atomic|offset|length|1096568|1096569|在上面创建的report.rdlc中添加数据集|1096570|现在，在MVC中创建一个ActionMethod，它将从数据库中查询数据并返回报表|1096571|+SSRSInMVC.Report.Report+ds+=+new+SSRSInMVC.Report.Report();
++++public+ActionResult+ReportStudent()
++++{
++++++++ReportViewer+reportViewer+=+new+ReportViewer();
++++++++reportViewer.ProcessingMode+=+ProcessingMode.Local;
++++++++reportViewer.SizeToReportContent+=+true;
++++++++reportViewer.Width+=+Unit.Percentage(900);
++++++++reportViewer.Height+=+Unit.Percentage(900);

++++++++var+connectionString+=+ConfigurationManager.ConnectionStrings["SSRSInMVC.Properties.Settings.StudentsConnectionString"].ConnectionString;


++++++++SqlConnection+conx+=+new+SqlConnection(connectionString);
++++++++SqlDataAdapter+adp+=+new+SqlDataAdapter("SELECT+*+FROM+Student_details",+conx);

++++++++adp.Fill(ds,+ds.Student_details.TableName);

++++++++reportViewer.LocalReport.ReportPath+=+Request.MapPath(Request.ApplicationPath)+%2B+@"Report\Report1.rdlc";
++++++++reportViewer.LocalReport.DataSources.Add(new+ReportDataSource("DataSet1",+ds.Tables[0]));


++++++++ViewBag.ReportViewer+=+reportViewer;

++++++++return+View();
++++}|1096572|在该视图中，代码如下所示|1096573|@using+ReportViewerForMvc;
@{
+++ViewBag.Title+=+"Report+Student";
+}
+ 
<br+/>

+++@Html.ReportViewer(ViewBag.ReportViewer+as+Microsoft.Reporting.WebForms.ReportViewer)|1096574|就是这样，我们完成了。|1096575|参考：https://qawithexperts.com/article/asp.net/displaying-ssrs-sql-server-reporting-service-in-mvc-view/77|1096576|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/1cae079d71a767f6a8f221de3b670878.png|imageAlt|1|LINK|MUTABLE|url|https://qawithexperts.com/article/asp.net/displaying-ssrs-sql-server-reporting-service-in-mvc-view/77^0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|3|2T|1|0^^$0|@$1|2|3|4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|1J|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|1K|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|1L|8|@]|9|@]|A|$]]|$1|K|3|L|5|M|7|1M|8|@]|9|@$N|1N|O|1O|1|1P]]|A|$]]|$1|P|3|J|5|6|7|1Q|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1R|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1S|8|@]|9|@]|A|$]]|$1|U|3|V|5|D|7|1T|8|@]|9|@]|A|$E|F]]|$1|W|3|X|5|6|7|1U|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|D|7|1V|8|@]|9|@]|A|$E|F]]|$1|10|3|11|5|6|7|1W|8|@]|9|@]|A|$]]|$1|12|3|13|5|6|7|1X|8|@]|9|@$N|1Y|O|1Z|1|20]]|A|$]]|$1|14|3|-4|5|6|7|21|8|@]|9|@]|A|$]]]|15|$16|$5|17|18|19|A|$1A|1B|1C|-4]]|1D|$5|1E|18|1F|A|$1G|1H]]]]

You can view report in MVC using ReportViewerForMvc, by installing it using Nuget
<pre><code>Install-Package Microsoft.Report.Viewer -Version 11.0.0

Install-Package Microsoft.ReportViewer.Runtime.WebForms -Version 12.0.2402.15

Install-Package ReportViewerForMvc
</code></pre>
Once you have installed the ReportViewer and other required Nuget packages as showed above, Add a new Report.rdlc in your Visual Studio project
<a href="https://i.stack.imgur.com/9hawU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9hawU.png" alt="enter image description here" /></a>
Add dataset in the above created report.rdlc
Now, create a ActionMethod in MVC, which will query data from database and return report
<pre><code> SSRSInMVC.Report.Report ds = new SSRSInMVC.Report.Report();
 public ActionResult ReportStudent()
 {
 ReportViewer reportViewer = new ReportViewer();
 reportViewer.ProcessingMode = ProcessingMode.Local;
 reportViewer.SizeToReportContent = true;
 reportViewer.Width = Unit.Percentage(900);
 reportViewer.Height = Unit.Percentage(900);

 var connectionString = ConfigurationManager.ConnectionStrings[&quot;SSRSInMVC.Properties.Settings.StudentsConnectionString&quot;].ConnectionString;


 SqlConnection conx = new SqlConnection(connectionString);
 SqlDataAdapter adp = new SqlDataAdapter(&quot;SELECT * FROM Student_details&quot;, conx);

 adp.Fill(ds, ds.Student_details.TableName);

 reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @&quot;Report\Report1.rdlc&quot;;
 reportViewer.LocalReport.DataSources.Add(new ReportDataSource(&quot;DataSet1&quot;, ds.Tables[0]));


 ViewBag.ReportViewer = reportViewer;

 return View();
 }
</code></pre>
In the view, you have code as below
<pre><code>@using ReportViewerForMvc;
@{
 ViewBag.Title = &quot;Report Student&quot;;
 }
 &lt;br/&gt;
&lt;br /&gt;

 @Html.ReportViewer(ViewBag.ReportViewer as Microsoft.Reporting.WebForms.ReportViewer)
</code></pre>
That's it, we are done.
Reference: <a href="https://qawithexperts.com/article/asp.net/displaying-ssrs-sql-server-reporting-service-in-mvc-view/77" rel="nofollow noreferrer">https://qawithexperts.com/article/asp.net/displaying-ssrs-sql-server-reporting-service-in-mvc-view/77</a>

Is there a way to put a SQL Server Reporting Services report viewer control on an ASP.net MVC view? If not...what is the best way to accomplish this?

Viewing SSRS Reports in an ASP.net MVC Site

Visual Studio

SQL Server

数据库

服务器

是否可以将SQL Server Reporting Services报表查看器控件放在ASP.net MVC视图上？如果not...what是实现这一目标的最佳方式呢？

问在ASP.net MVC站点中查看SSRS报表
EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在ASP.net MVC站点中查看SSRS报表EN

回答 5

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在ASP.net MVC站点中查看SSRS报表
EN