Reading XML in SSRS

Question

I have a filed in a table in Oracle that contains and 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?

Answer 1

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