CODEWITHSUNDEEP
web-servicesreporting-services
Tobias
Tobias

Reputation: 5108

How to use WebService of SQL Server 2008 Reporting Services

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.

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.

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.

What am I missing here?

Upvotes: 9

Views: 42285

Answers (3)

Rufus
Rufus

Reputation: 61

Check in the following folder: C:\Program Files\Microsoft SQL Server\MSRS10.OSSSQL2008\Reporting Services\ReportServer\

There are two files: -ReportService2005.asmx -ReportExecution2005.asmx

Combine these with your url above "http://servername:81/ReportServer" to form the correct link to your webservice i.e. "http://servername:81/ReportServer/ReportService2005.asmx?wsdl"

Upvotes: 2

Franklin
Franklin

Reputation: 21

http://localmachinename:8080/ReportServer/reportservice2005.asmx?WSDL

Upvotes: 2

davidsleeps
davidsleeps

Reputation: 9503

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

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...

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

so yours might be:

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

Upvotes: 12

Related Questions