How to create Datasource /dataset from XML file.

[AnNguyen]

Hello
I'm new to this Reporting services, and I wonder if RS can retrieve data from a pre-determined XML file.But first let me explain my problem.

I get the XML file from a third party which i can not modify, is it posible that i can create a datasource/dataset to this file an retrieve data from there
and make a report out of it. Below it a simpler copy of the XML file. (it is copied to fixed directory in the server)

<List>
<cust><name>AAA</name><otherinfo>OTHER</otherinfo></cust>
<cust><name>BBB</name><otherinfo>OTH1</otherinfo></cust>
<cust><name>ABC</name><otherinfo>OTH2</otherinfo></cust>
......
</List>

Please help or point me to some document to solve this.
Thank you.

 

[RiverGuy]

When I select to make a new connection, XML is one of the options. Have you tried selecting this?