nested XML data

fishdan

I am using an XML dataset like this:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>
<?xml version="1.0" encoding="UTF-8"?>
<people>
<person>
<name><![CDATA[John]]></name>
<phone>
<type><![CDATA[home]]></type>
<number><![CDATA[314-159-2653]]></number>
</phone>
<phone>
<type><![CDATA[cell]]></type>
<number><![CDATA[271.828.1828]]></number>
</phone>
</person>
<person>
<name><![CDATA[Mary]]></name>
<phone>
<type><![CDATA[mobile]]></type>
<number><![CDATA[987-159-2653]]></number>
</phone>
</person>
<person>
<name><![CDATA[Steven]]></name>
<phone>
<type><![CDATA[home]]></type>
<number><![CDATA[222-159-2653]]></number>
</phone>
<phone>
<type><![CDATA[work]]></type>
<number><![CDATA[(872) 828-1828]]></number>
</phone>
<phone>
<type><![CDATA[Skype]]></type>
<number><![CDATA[555.828.1828]]></number>
</phone>
</person>
</people>

</pre>
<br />
I want to make a table that displays the person's name in the left column and then has a sub table in the right column. That table has two columns, the left is the phone type, and the right is the number.<br />
<br />
so the tables would look like:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>John | Home : 314-159-2653
| Cell : 271.828.1828

---

Mary | Mobile : 987-159-2653

---

Steve | Home : 222-159-2653
| work : (872) 828-1828
| Skype : 555.828.1828</pre>
<br />
<br />
My problem is that if I create one dataset I only get one phone for each person.<br />
I can create a dataset for phones, but then I get the same phone data repeated for each person.<br />
<br />
I've attached my report design and my dataset.<br />
<br />
Thoughts/solutions appreciated.

fishdan

I figured it out. The answer is to use two tables, and then assign the person dataset the outer table and the phones dataset to the inner. Then apply a filter to the inner table

row["name"] Equal to row._outer["name"]

gravy.

Solution attached, you can use the data from the previous post.

I do still wonder if it could be done with one dataset...