Reporting on complex XML

[Michael Salzlechner]

I am creating a report based on a complex XML document. The XML document contains several nested child hierarchies which mostly seem to work fine using subreports

One thing i am trying to figure out is the following

say the XML doc looks like this

<root>
     <childinroot>
           <field1>ffdfd</field1>
           <field2>ffdfd</field2>
           <field3>ffdfd</field3>

           <childinchild>
                <grandchild>value</grandchild>
           </childinchild>

     </childinroot>
</root>

if i create a datasource i can access the fields (field1, field2, ..) in the report but is there any way to get to the grandchild field without having to use subreports ?

thanks

Mike

[Michael Salzlechner]

Not sure if this is the best solution but for no wi decided to use an XSL transform to transform the XML into something a bit more readable for DataSets

Mike