I am using Microsoft Sql Server Report Builder 3.0 and need to pull in an Xml data field node. My Datasource1 is the main table and the xml is in the column XmlDataField. The query below extracts the node I am interested in. Do I have to create a second datasource to retrieve the Xml or is there an easier way?
Select XmlDataField.value('(//*[local-name()="Text2Size50"])', 'nvarchar(max)')
Where Type = '72'