Prev: set credentials on datasource with SetExecutionCredentials method
Next: Localization of reports
From: Liligirl on 20 Sep 2006 09:01
Hi,

I was working on the MSDN Tutorial "Using XML Data in a Report", Lesson
2: Defining a Report Dataset for an ADO.NET DataSet from a Web Service
at the follwoing link
http://msdn2.microsoft.com/en-us/library/aa337489.aspx

When i run the following query, everything goes as expected (i.e. the
displayed data is the extracted data from all XML elements and
attributes down to the leaf node on the first XML path it finds in the
dataset )

<Query>
<SoapAction>
http://tempuri.org/GetEmployeeManagers
</SoapAction>
<Method Namespace="http://tempuri.org/"
Name="GetEmployeeManagers">
</Method>
</Query>

But when i add the other section to specify the elements to be used in
retrieving the data

<ElementPath IgnoreNamespaces="True">
GetEmployeeManagersResponse {}/
GetEmployeeManagersResult/diffgram{}/
Results {}/Table
</ElementPath>

the following error is dispalyed:

===================================

An error occurred while creating a data extension command.
The XmlDP query is invalid. (Microsoft Report Designer)

The XmlDP query is invalid.
(Microsoft.ReportingServices.DataExtensions)

There are multiple root elements. Line 9, position 2. (System.Xml)

===================================

I would appreciate much if u helped me in this problem

Thank you,

 | 
Pages: 1
Prev: set credentials on datasource with SetExecutionCredentials method
Next: Localization of reports