Creating Report on Local XML File

Hey All,

I am attempting to create a report on SQL Reporting Services that uses a local XML file as its datasource. Although i did not find a way to directly do this, I found an MSDN article that walks a person through on how to use a report parameter to paste in your XML data from the page. When I set up the report in this way, I get an "Invalid URI" error when I go to the preview tab.

http://msdn2.microsoft.com/en-us/library/aa964129.aspx

What would be the best way for me to use an XML file as a datasource using reporting services? Is there a way that I can use a local file and use a parameter to point at that file?

Any info, links, tuts, etc. would help. Thanks!

Nathan

The XML Provider you are testing requires an url-addresable file, e.g. putting the file in wwwroot and using http://filename as URL.

Alternatively, you could write a custom data extension, as explained in this article. Another article to check is this.