大家好..这是我第一次编写 ASP.NET MVC Web 应用程序，而且进展顺利。我在那里没有问题。不过我对 SSRS 没有任何经验。最终我希望能够在我的 ASP.NET MVC 应用程序上呈现报告。
- 我已安装并运行报表服务器，并且它在 SQL Server Management Studio 中可见。
- 我通过 Business Intelligence Development Studio 创建了一个测试报告 (.rdl)，并将其发布到我的报告服务器。我查了一下，现在就在那里。
我的问题是如何将其绑定到我的主应用程序中？我是否必须在主应用程序中添加引用才能检索我创建的报告？我完全迷失了 - 我的主数据库和报表服务器在 SQL Server Management Studio 中都可见。据我所知...帮助？？？提前致谢..！
Hey everyone.. This is my first time writing an ASP.NET MVC web app, and it's going good. I have no problems there. What I don't have any experience in is SSRS though. Ultimately I want to be able to render reports on my ASP.NET MVC app.
- I got the report server installed and running, and it's visible within SQL Server Management Studio.
- I created a test report (.rdl) via Business Intelligence Development Studio, and published it to my report server. It's now there, I checked.
My question is how do I tie that into my main application? Do I have to add a reference in my main application to be able to retrieve the report I created? I'm totally lost- I have my main database and my report server both visible within SQL Server Management Studio. That's as far as I got... help???? Thanks in advance..!
发布评论
评论（1）
试试这个： http://geekswithblogs.net/stun/archive/2010/02/26/executing-reporting-services-web-service-from-asp-net-mvc-using- wcf-add-service-reference.aspx
如果您是 ASP.NET MVC 新手，并且不特别需要通过 BI Development Studio 创建的 MS Reporting Services (
.rdl)，则失败了，但对标准 Visual Studio 报告 (.rdlc) 感到满意（这仅仅意味着该报告可能或多或少仅链接到单个应用程序。您可以通过 Visual Studio 项目创建这些报告 - 右键单击 - >新项目->报告）看看这个链接（http://www.danielroot.info/2009/06/how-to-render-reporting-services.html），尽管它说明了如何链接 Reporting Services，但实际上他表示标准报告.rdlc文件。本质上，它只是将.rdlc报告的输出发布为.pdf并将其流式传输给您的用户，我发现它非常简单，也是一种强大的方法快速发布报告。如果无法混合使用这两种实现，您可能可以正确流式传输报告服务
.rdl。祝你好运。
Try this: http://geekswithblogs.net/stun/archive/2010/02/26/executing-reporting-services-web-service-from-asp-net-mvc-using-wcf-add-service-reference.aspx
Failing that, if you are new to ASP.NET MVC and you do not specifically require MS Reporting Services (
.rdl) created through BI Development Studio, but are satisfied with a standard Visual Studio Report (.rdlc) (This simply means the report may be more or less linked only to the single app. You create these via Visual Studio Project - Right Click -> New Item -> Reporting -> Report) take a look at this link (http://www.danielroot.info/2009/06/how-to-render-reporting-services.html), even though it states how to link Reporting Services, he actually means standard reporting.rdlcfiles. In essence it publishes simply the output from an.rdlcreport as a.pdfand stream it to your user, I have found it to be incredibly simply and a powerful way to quickly publish reports.Failing that a hybrid of both implementations might allow you to stream your Reporting Service
.rdlcorrectly.Good luck.