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

Conditional formatting a graph vertical axis in SSRS 2012 charts

Register with Power BI failed

SQL server replication error Cannot find the dbo or user defined function........