SSRS-XML issue


i have field in database table contains xml string. not formatted. in report need display formatted xml

xml, highlight option, tree view expand/collapse  option on each node. able achieve formatting below script

public function formatxml(file_content string)as string 

dim doc new system.xml.xmldocument() 

doc.loadxml(file_content) 

dim sb new system.text.stringbuilder() 

  dim settings new system.xml.xmlwritersettings() 

  settings.indent = true 

  settings.indentchars = "    "     ' includes 4 non-breaking spaces: alt+0160 

  settings.newlinechars = system.environment.newline 

  settings.newlinehandling = system.xml.newlinehandling.replace 

  settings.omitxmldeclaration = true 

  using writer system.xml.xmlwriter = system.xml.xmlwriter.create(sb, settings) 

    doc.save(writer) 

  end using 

  return sb.tostring() 

end function

but not working ie version.mainly trying  tree view expand/collapse  option on each node in report .  please me in resolving issue



SQL Server  >  SQL Server Reporting Services, Power View



Comments

Popular posts from this blog

SQL Server PSProvider SQL Server Authentication

Reindexing

How to calculate the delta size while diffing the files in TeamFoundationServer ?