This is a migrated thread and some comments may be shown as answers.

Reporting on complex XML

1 Answer 54 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Michael Salzlechner
Top achievements
Rank 1
Michael Salzlechner asked on 05 Dec 2010, 04:32 PM
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

1 Answer, 1 is accepted

Sort by
0
Michael Salzlechner
Top achievements
Rank 1
answered on 05 Dec 2010, 08:28 PM
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
Tags
General Discussions
Asked by
Michael Salzlechner
Top achievements
Rank 1
Answers by
Michael Salzlechner
Top achievements
Rank 1
Share this question
or