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

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.