如何使用 SQL Server 2008 Reporting Services 的 WebService [英] How to use WebService of SQL Server 2008 Reporting Services

问题描述

我创建了一份报告并将其发布到运行良好的 Report Server 2008.我可以在浏览器中调用 http://servername:81/Reports 并查看和导出报告.我现在想要做的是编写一个应用程序，使用该报告创建一个 Excel 文件.

I created a report and published it to the Report Server 2008 that worked fine. I can call http://servername:81/Reports in my browser and view and export the reports. What I want to do now is write an application that uses the report to create a Excel file out of it.

根据 Reporting Services 配置管理器，该报表服务器的 Web 服务位于 http://servername:81/ReportServer.当我在浏览器中打开链接时，我可以看到我使用 Visual Studio 创建和部署的项目的文件夹.

According to the Reporting Services Configuration Manager the WebService of that Report Server is located at http://servername:81/ReportServer. When I open the link in my browser I can see the folders of the projects I created and deployed using Visual Studio.

但是我在那里找不到 Web 服务端点.在 VS 中，当我尝试添加 Web 引用时，也找不到 Web 服务.

But I can't find a web service endpoint there. In VS when I try to add a web reference no web service can be found there either.

我在这里遗漏了什么?

推荐答案

也许你还没有指定 .asmx(网络服务)地址...

Maybe you haven't specified the .asmx (web service) address...

这篇 MSDN 文章来自 SQL Server 2008 Books Online应该有用.另请注意使用 Web 服务构建应用程序的其他资源"链接...

This MSDN article is from the SQL Server 2008 Books Online which should be useful. Also note the "Other Resources" link to Building Application using the Web Service...

只需检查我们使用 Web 服务的应用程序之一的配置文件，并且存储的地址是:

Just checking the config file for one of our applications that uses the web service and the address stored is:

http://SERVER_NAME/ReportServer/ReportService.asmx

所以你的可能是:

http://SERVER_NAME:81/ReportServer/ReportService.asmx

这篇关于如何使用 SQL Server 2008 Reporting Services 的 WebService的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！