Friday, March 30, 2012

Reporting Services Tutorials Problem

Hi, I'm having a problem with the 6th tutorial of the Reporting Services: Using XML Data in a Report. Im using SQL Server Standard Edition on Windows server 2003.

In 'Lesson 1: Defining a Data Source and Dataset for XML Data' (http://msdn2.microsoft.com/en-us/library/ms345338.aspx), I can't seem to get steps 10 to 15 right.

In Step 10, it says you must type :

"<Query> <SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportservices/ListChildren</SoapAction> </Query>"

But in the diagram it has .../reporting/reportingservices/ListChildren...

Well I tried both(The namespace info from "http://localhost/reportserver/reportservice2005.asmx?wsdl" uses the latter.) but I get the error:

An error occurred while executing the query.

Failed to execute web request for the specified URL.

What am I doing wrong?

The schema information is wrong in the tutorial. We've fixed it for the next release. The following schema namespace should work for you:

Query>
<SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListChildren</SoapAction>
</Query>

|||

After typing the query as stated in the last post being:

<Query>
<SoapAction>http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListChildren</SoapAction>
</Query>

I still get the same error. What is the correct syntax in order to get this to work?

Thanks

No comments:

Post a Comment