Reporting Services Web Service provides a communication interface for Report Server and the client applications. It uses SOAP over HTTP and provides two endpoints (one for report server execution and one for management). The web services provides multiple methods and types which can be used to play around with Reporting Services.
SSRS 2005 and SSRS 2008 expose three different endpoints, which are defined in different WSDL(Web Service Description Language) files.
- ReportService2005: This is used to manage and work with Report Server which is running in the Native Mode. The WSDL for this endpoint is typically defined as
http://<servername>/<reportserver>/ReportService2005.asmx?wsdl
Where <servername> is the name of the Machine where SSRS is installed and <ReportServer> is the virtual directory name for Reporting Services web service.
- ReportService2006: This is used to manage and work with Report servers which are running in the SharePoint Integration Mode. The WDSL for this endpoint is.
http://<servername>/<reportserver>/ReportService2006.asmx?wsdl
- ReportExecution2005: This endpoint is used to control Report Server Execution. for example, to stop a running subscription.The WDSL for this endpoint is.
http://<servername>/<reportserver>/ReportExecution2005.asmx?wsdl
With SSRS 2008 R2, the functionalities of (ReportService2005 and ReportService2006, now depricated) endpoints were integrated to a single WSDL, ReportService2010.
In order to use these WSDL’s in your application, a web service reference should be added. In case, if we do not want to add a web service reference, we can use the Visual Studio utility WSDL.exe to generate a proxy class for these endpoints and add it to the application.
In this post, I will be talking about how to use WSDL.exe to generate a proxy class for Reporting Services. On my Laptop running Windows7, WSDL.exe is located in the following folder.
“C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bin”
Open a Command Prompt window and browse to the above mentioned folder. From the command prompt launch the WSDL.exe. For generating the proxy class, the following Parameters should be enough.
<url or path> A url or path to a WSDL contract, an XSD schema or .discomap document.
/language:<language> The language to use for the generated proxy class. Choose from ‘CS’,’VB’, ‘JS’, ‘VJS’, ‘CPP’ or provide a fully-qualified name for a class implementing System.CodeDom.Compiler.CodeDomProvider. The default language is ‘CS’ (CSharp). Short form is ‘/l:’.
/out:<fileName|directoryPath> The filename or directory path for the generated proxy code. The default filename is derived from the service name. Short form is ‘/o:’.
Let’s say, we need to create the proxy class for the ReportService2005 endpoint, the WSDL.exe command would be
wsdl.exe "http://<ReportServerHostName>/reportserver/ReportService2005.asmx" /l:CS /out:"D:\RS2005.cs"
On successful completion, you should see the following information in the Command Prompt.
Microsoft (R) Web Services Description Language Utility
[Microsoft (R) .NET Framework, Version 2.0.50727.1432]
Copyright (C) Microsoft Corporation. All rights reserved.
Writing file 'D:\Test.cs’.
Once the File is generated, it can be added to you project as a class file. Using the following steps.
- In your Visual studio project, open Solution Explorer and Right Click on your Project and click on Add, Existing item.
- In the Add Existing Item dialogue box, locate the RS2005.cs file saved above and add it.
- Once the RS2005.cs, file has been added, we can use the classes/methods just like any C# class.
Details about the methods and functionalities provided by these endpoints can be found at
ReportService2005
ReportService2006
ReportExecution2005
ReportService2010
In the next post, I will talk about how to add a Reporting Services Web Service Reference to your project.
SQLUNINTERRUPTED 