Reputation: 9279
I have a field in a table in Oracle that contains an XML formatted string. In this string is a node value that I need. How can I parse an XML string contained in a database column/field?
Upvotes: 2
Views: 7665
Reputation: 3690
you have two options either pre-shred the xml on the db side or use an xml datasource in SSRS.
The tricky part is to setup up the data source as embedded xml and have the value come from an ssrs expression which uses the xml column from the db as the embedded data, plus adds the query syntax. this can be done using string concatenation in the expression
Here is an article that shows the syntax: http://msdn.microsoft.com/en-us/library/ms345251.aspx
Upvotes: 3