i have an xml data source with the following structure
<model xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
<folder name="Application" id="8194d772" type="application">
<element type="ApplicationComponent" id="71031456" name="Apache Sling"/>
<element type="ApplicationComponent" id="f0baee63" name="Apache"/>
</folder>
<folder name="Relations" id="df19ab5b" type="relations">
<element type="AggregationRelationship" id="b2adb66d" source="f0baee63" target="71031456"/>
<element type="CompositionRelationship" id="ca16a011" source="f0baee63" target="71031456"/>
</folder>
</model>
the report should list the rows like this...
| source | relation | target |
| Apache | AggregationRelationship | Apache Sling |
The datasource is setup as an XML data source with the xpath "/model/folder[@type=relations]/element"
That setup exposes the relations fields, but how to de-reference the source and target guids within the same report or subreport so that it prints into a single row doesn't appear so obvious.
the xpath to dereference source/target would look like
"/model/folder[@type=application]/element[id=$F(source)]/name"
(after 12 hours of head banging to get here...)
i could use some help figuring out to apply that knowledge to a report design...