Reporting Services 2005 - XML stored in DB as data source
Hello, i need to implement current scenario: 1. the report will have an ID as input parameter 2. according to this ID it will pull out an XML from database table 3. use the XML as data source and I have no even an idea where to start. Could anybody be so kind and help me with this? Thank you in advance
October 7th, 2010 10:13am
SSRS's SQL Data extension does not allow you to read XML columns directly. There are several appraoches: 1) SQL Server's T-SQL language allows you to build T-SQL Queries which retrieve data from XML Columns. This is the easiest, and recommended way to ccomplish this 2) host a web service that exposes the XML through http, which would allow the RS XML data provider to read it. I would not recommend this approach since it is complex. Learning how to use SQL Server's XML features here: http://msdn.microsoft.com/en-us/library/bb522493.aspx http://msdn.microsoft.com/en-us/library/ms191214.aspx Hope this helps, -LukaszGot a bug or feature request? Tell me about it at http://connect.microsoft.com. This posting is provided "AS IS" with no warranties, and confers no rights.
October 12th, 2010 5:51pm