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
Post a Comment