Visual Studio 2010 - ASP.NET MVC3 应用程序 - SQL Server 2005 上的 SSRS
我对 SSRS 有点陌生...我有一个 MVC3 应用程序，我需要显示来自 SQL Server 2005 数据库的 SQL Server 报告。这可能吗？我问这个问题是因为我的谷歌搜索表明 VS2008/SQL Server 2005 存在一些问题，所以想知道这些问题在 VS2010 中是否仍然存在。
另外，在 MVC3 应用程序中嵌入报表查看器控件是否非常简单？我看过一些帖子，但还没有太多细节。
非常感谢链接和反馈。另一个问题 - 我是否直接在我的网络应用程序/报告查看器中进行报告设计？或者，我是否必须先设计报告（例如在“报告应用程序”中）？
I'm a bit new to SSRS... I have an MVC3 application which I need to show SQL Server reports from a SQL Server 2005 database. Is this possible? I ask because my google searches indicated some problems with VS2008/SQL Server 2005, so wanted to know if these issues still persist for VS2010.
Also, is it pretty straight forward to embed the Report Viewer control in an MVC3 application? I've seen a few posts, but not too much details yet.
Links and feedback would be very much appreciated. Another question -- do I do the report designing directly in my web-app / report viewer? Or, do I have to design the report first (e.g. in a "Report Application")?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
好吧，你应该把这个分成两个不同的问题。首先，关于在 ASP.NET MVC 中使用报告，这可能非常具体 - 我希望您必须回到 ASP.NET 页面来处理这种情况，但让其他有更深入理解的人回答这个问题。
第二部分是关于报告本身的设计。您在互联网上阅读的问题正是针对这个问题。报表可以在报表生成器中创建，报表生成器是一个独立的应用程序，具有与 MS Office 类似的界面，也可以在商业智能开发工作室中创建，它是 SQL Server 工具安装的一部分。
商业智能开发工作室构建在 VS Studio shell 之上。 VS Studio 的每个版本都有自己的 shell 版本，每个商业智能开发工作室都使用发布时提供的 VS studio 的 shell。因此，对于 SQL Server 2005，shell 基于 VS Studio 2005，因此您将不会在 VS 2010 中看到商业智能项目和项目（如报告），而必须直接使用商业智能开发工作室。
Well you should devide this into two different questoins. First about using reports in ASP.NET MVC which can be quite specific - I expect you will have to fall back to ASP.NET page for this case but let others with deeper understanding answer this question.
The second part is about designing the report itself. The issues you read on internet targets exactly this problematics. Reports are either created in Report Builder which is separate application with similar interface as MS Office or in Business intelligence development studio which is part of SQL server tools installation.
Business intelligence development studio is build on top of VS Studio shell. Each version of VS Studio has its own version of the shell and each Business intelligence development studio uses the shell of VS studio available in the time of its release. So for SQL Server 2005, the shell is based on VS Studio 2005 and because of that you will not see business intelligence projects and items (like reports) in VS 2010 and you will have to use Business intelligence development studio directly.
是的，首先设计报表并部署在报表服务器上，然后使用报表查看器控件在应用程序中呈现报表。
yes, first design report and deploy on report server, then use report viewer control to render report in application.