How to create reports in SQL Server 2005/2008 Reporting Services using XML data?

Any suggestions on how to create report开发者_如何学Python/s in SQL Server Reporting Services using XML data (found in existing table/s)?

It's actually easier than you might've originally thought.

1. Create a stored procedure that shreds the xml and outputs the underlying info in a nice tabular form.
2. Process this data in SSRS using this stored procedure as data source.

Read about xml shredding here: XML Support in Microsoft SQL Server 2005

I'm not an SSRS expert but from what I understand I think you might need to create the xml first before and use the XML data source to create your data set. So basically, I'm suggesting a two step process. Export the data to an xml file from Sql Server in step 1 and in Step 2 use the XML data source type to connect to the xml file and generate the SSRS report.

If you directly connect to Sql Server through SSRS, you'll get raw xml data with all the tags and everything and I don't think SSRS will allow you to (programmatically or otherwise) display this raw xml data in proper format.