SQL Sever 2008 R2 报告集成到 ASP.NET 站点
我使用“SQL Server 商业智能开发”创建了一些可爱的报告,创建了一个“报告服务器项目”。我已将它们部署到 SQL Server 报告服务并在线查看,它们看起来很棒!
问题是...我可以将这些报告集成到我的 ASP.NET Webforms 站点中吗?例如,我可以将值传递给我的存储过程,并使用前面提到的创建的相同报告生成端口。
这可能吗?如果是这样,请指教。
谢谢
I have created some lovely reports using "SQL Server Business Intelligence Development" creating a "report Server Project". I have deployed these to SQL Server reporting services and viewed online and they look great!
Question is...can I integrate these reports into my ASP.NET webforms site? So for example I could pass in values to my stored procedure and the port is generated using the same reports created previously mentioned.
Is this possible? If so, please advise.
Thanks
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
将服务报表集成到网站的最简单方法是使用 ASP.NET ReportViewer 控件。我自己没有使用过这个,但它很简单,只需要将报告部署到可访问的报告服务器(您已经完成了)。
您还可以制定自己的 url 来创建指向 PDF 版本报告的直接链接,如下所示:
最后,您可以使用页面或处理程序作为中介,通过调用报告服务器的 Web 服务并处理结果(可以简单地通过 Response .BinaryWrite(结果)。
The simplest way to integrate serving reports into your website is to use the ASP.NET ReportViewer control. I've not used this myself, but is is straight forward and just requires that the reports are deployed to an accessible report server (which you have already done).
You can also formulate your own url to create a direct link to a PDF version of the report as follows:
Finally, you can use a page or handler as an intermediary by call the Report Server's web service and processing the result (possible simply by Response.BinaryWrite(result).