Does anyone know what the difference is between the two web service endpoints ReportService2005.asmx and ReportExecution2005.asmx in SQL Server Reporting Services? is there an article that I can go through? Thanks.
Asked
Active
Viewed 1.6k times
14
-
Note the differences between the different SQL Server versions – BozoJoe Mar 14 '14 at 23:23
3 Answers
11
The ReportExecution2005 endpoint allows developers to programmatically process and render reports in a report server. The WSDL for this endpoint is accessed through ReportExecution2005.asmx?wsdl.
The ReportService2005 Web service (reportservice2005.asmx) allows developers to programmatically manage objects in a report server.
Mitch Wheat
- 295,962
- 43
- 465
- 541
-
2The ReportService2005 and ReportService2006 endpoints are deprecated in SQL Server 2008 R2. The ReportService2010 endpoint includes the functionalities of both endpoints and contains additional management features. – BozoJoe Mar 14 '14 at 23:45
9
As Mitch says, ReportExecution2005 is for executing reports, handling drilldown, rendering, etc. and ReportService2005 is used for creating things (data sources, subscriptions, even reports), as well as updating, deleting, querying, etc.
Two handy references are the MSDN method listings for ReportExecutionService (ReportExecution2005 web service endpoint) and ReportingService2005 (ReportService2005 web service endpoint).
Don't confuse these with the ReportService2006 endpoint, which is used if you have SSRS configured for Sharepoint integrated mode.
Hope that helps!
Peter Mularien
- 2,578
- 1
- 25
- 34
2
ReportService2005
- Enables you to manage a report server and its contents including server settings, security, reports, subscriptions, and data sources.
- Can be accessed by:
http://servername:port/ReportServer/ReportService2005.asmx?wsdl
ReportExecution2005
- Enables report execution
- Can be accessed by:
http://servername:port/ReportServer/ReportExecution2005.asmx?wsdl
