XML as Data Source

Question

Dear Forum Members,

 

I need is help on this:

Assume, we have Microsoft Example XML as Data Source for our report (I am using Microsoft Example from the link http://msdn2.microsoft.com/en-us/library/ms365158.aspx)

 

I would like to see the following: 

Customer/Order Details	Item Ordered	Quantity Ordered	Item Returned	Quantity Returned
Bobby Moore	Chair	6
Crystal Hu	Sofa	2
Wyatt Diaz	EndTables	2

 

That is, I need to have Items Returned and Quantity Returned for every Customer,- we do have this data in our XML example. 

P.S. How do I parameterize XML? 

For example, I would like to have Order ID as a parameter, and then I pass it to 

                <Query>

(Here I need help for the syntax)

                </Query>

 So I will get Customer FistName, LastName, his Id, and so on.

This is the part of XML

                 - <Customer ID="11">

                                <FirstName>Bobby</FirstName>

                                <LastName>Moore</LastName>

                                - <Orders>

                                                <Order ID="1" Qty="6">Chair</Order>

                                                <Order ID="2" Qty="1">Table</Order>

                                </Orders>

                                - <Returns>

                                                <Return ID="1" Qty="2">Chair</Return>

                                </Returns>

                </Customer>

Thank you very much,

Alfred.

Answer 1

ProJester,

Try this format for your query:

<Query>
<Method Namespace = "http://FindSomethingWebService/" Name = "FindSomething"/>
<SoapAction>http://FindSomethingWebService/FindSomething</SoapAction>
</Query>

Then set up your Order ID parameter by clicking on the elipses (...), after the dataset combobox, and go to the Parameters tab.

You will get the method namespace from the WebService.asmx?wsdl file.  The Name is the method name inside your web service.

Reporting Services will automatically parse the incoming XML file and generate a dataset for you.