MikeTWebb
MikeTWebb

Reputation: 9279

Reading XML in SSRS

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

Answers (1)

Jason Horner
Jason Horner

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

Related Questions