SSRS 2005 Web Service Issue
I added the SSRS Web Service to my VS 2008 Project and found some of the methods are simply not exposed or I am doing something wrong (which is most certainly the case). Below is the article I am referencing:
http://msdn.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx
Here the URL I used for the service:
http://192.168.XXX.XXX/reportserver/ReportService2005.asmx?WSDL
SQL Server: 2005 (SP2)
Below is my code:
Imports System.IO
Imports System.Web
Imports TestJunk.SSRS_WebService 'Designated Name of Service
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim MyRS As New ReportExecutionService()'Error: Type 'ReportExecutionService' is not defined
End Sub
End Class
October 18th, 2010 8:30pm
In reviewing this issue more thoroughly I discovered the below classes are the only classes exposed:
ReportHistorySnapshot
ReportingService2005SoapClient
ReportParameter
VS 2008
2005 SQL Server Reporting Services Web Service
Anyone with any thoughts? Thanks in advance!
Free Windows Admin Tool Kit Click here and download it now
October 19th, 2010 3:53pm
Hi BKitchen,
The Report Server Web service provides several endpoints for managing a report server as well as executing and navigating reports. For example:
·
The Management Endpoint such as
ReportService2005 is used for managing objects on a report server. It can be accessed by the URL like: http://<Server Name>/ReportServer/ReportService2005.asmx?wsdl
·
The Execution Endpoint
ReportExecution2005 is used for developers to customize report processing and rendering from a report server. In native mode, it can be accessed by the URL like: http://<Server Name>/ReportServer/ReportExecution2005.asmx?wsdl
From the article and code you posted, you try to create a custom application for report rendering. So please add the web service
ReportExecution2005 rather than
ReportService2005 by the URL like:
http://192.168.XXX.XXX/reportserver/ReportExecution2005.asmx?WSDL
For more information about Report Server Web Service Endpoints, please see:
http://msdn.microsoft.com/en-us/library/ms155398(v=SQL.90).aspx
Thanks,
Tony Chain
Please remember to mark the replies as answers if they help and unmark them if they provide no help
October 20th, 2010 9:28am
Tony,
THANK YOU so much! Clearly this is something I should have picked up on my own. :)
Thanks,
Bobby
Free Windows Admin Tool Kit Click here and download it now
October 20th, 2010 1:31pm