XML records

[McNasti]

Hi All,

I'm Running CR10, XML Datasourse. My sample XML is as follows:

<LocationList oid="1">
<Location id="Location_2" oid="2">
<Name>Lansking</Name>
<Description>Headquaters<Description/>
<Type>PHYSICAL</Type>
</Location>
<Location id="Location_3" oid="3">
<Name>Hamberg</Name>
<Description>Building<Description/>
<Type>PHYSICAL</Type>
</Location>

<Territory id = "Territory_1>
<AlphaLocationRef idref="Location_2"/>
<BetaLocationRef id="Location_3"/>
</Territory>

Id like to create a tabular report, that would display as follows:

Territory_1
AlphaLocation BetaLocation
------------- ------------
Lansking Hamburg

When reporting with XML i'm establishing relationships from within the select expert, for example with the sample above I would normally set locationid = location idref, for the above structure this will not work.

Thanks for any ideas and help in advance.

M