How to parse and display as column XML column value

• shahzadazizpk

  Old Hand

  Points: 381

  More actions

  November 24, 2015 at 10:34 pm

  #322549

  Hi Everyone,

  I am developing a SSRS report in which I need to show table output but one column consist data with XML tags, so I need to parse each XML tag and display into different columns of the report

  Column data

  <ACCOUNTFROM>XXXX</ACCOUNTFROM> <ACCOUNTTO>YYYYY</ACCOUNTTO> <AMOUNT>ZZZZ</AMOUNT> <REMARKS>REM</REMARKS>

  Expected output

  Column Name--------Value

  ----------------------------------------------------

  ACCOUNTFROM------XXXX

  ACCOUNTTO---------YYYYY

  AMOUNT-------------ZZZZ

  REMARKS------------REM