Forum Discussion
Working with XML data
I need to show xml data in my report. This data is stored in an SQL table. How do I extract parts of this xml and convert it into a tabular data? I am doing it in my SSRS report, but copying and past...
Hi Markzolotoy,
I'd like to suggest you enter to query editor, add a custom column and try to use xml.document/xml.table to analysis this xml column, then expand the analysed xml table.
Accessing data functions
| Xml.Document | Returns the contents of an XML document as a hierarchical table (list of records). |
| Xml.Tables | Returns the contents of an XML document as a nested collection of flattened tables. |
Regards,
Xiaoxin Sheng