December 7, 2005 at 10:15 am
How do I use a web service as an XML data source in a reporting services 2005 report? Are there any walkthroughs our samples available on the web. I have tried looking on the Microsoft site but haven't found much, other than mention that it is possible.
I am not clear how to:
1. Create/Setup the data source
2. Build the query.
December 8, 2005 at 9:58 pm
Did you install the 2005 documentation with your local install? I did a search for (without the quotes) 'web service data source' filtering only to Reporting Services and it returned the instructions & example of how to do this.
Steve.
December 8, 2005 at 10:18 pm
I just followed their quick walk-through, works a treat.
The simplified steps are:
1. create a new datasource, set it to XML type
2. in the conxn string section, set to web service URL (eg http://localhost/reportserver/reportservice.asmx)
3. start new report
4. set the query to be (note that the namespace is different for different RS versions, I pointed to RS2000)
<Query><SoapAction>http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices/ListChildren</SoapAction><ElementPath /></Query>
5. (for this particular web service call) set the parmeter values (Item --> / and Recursive --> 0 )
6. Click OK then click the bang (!) to run the query and it returns the data as expected.
Steve.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply