someone posted this to me, so I don't know the source of the text

Connecting to an XML data source

To retrieve XML data in a report, create a dataset that specifies a URL to
the XML document. The following example illustrates the connection string
syntax. Enclosing the URL in quotes is optional. Note that the file://
protocol is not supported.



Copy Code

URL="http://adventure-works.com/results.aspx"





To retrieve an XML document from a Web Service, you must specify the
SOAPAction property. The property value is the SOAP method you want to use.
If the method has parameters, you must specify them as parameters on the
dataset (Report Designer includes a Parameters tab on the DataSet dialog
where you can specify query parameters):



Copy Code

URL=<url>; SOAPAction=<method-uri>[#|/]<method-name>





The URL is the location of the Web service SOAP endpoint. Note that the
delimiter between the method URI and the method name depends on the Web
service you are using. The following example illustrates the syntax:



Copy Code

URL=http://localhost/reportserver/reportservice2005.asmx;
SOAPAction="http://schemas.microsoft.com/sqlserver/2004/05/reporting/reportservices/ListChildren"





[quoted text, click to view]