Jump to content
We've recently updated our Privacy Statement, available here ×

How to concat nested list in the Table with XML Datasource


botyro

Recommended Posts

Hi all,

<report><table>    <persons>        <person>            <id>111</id>            <name>John</name>            <addresses>                <address>Johan's Street 1</address>                <address>Johan's Street 2</address>                <address>Johan's Street 3</address>            </addresses>        </person>        <person>            <id>222</id>            <name>Marko</name>            <addresses>                <address>Marko's Street 1</address>                <address>Marko's Street 2</address>            </addresses>        </person>        <person>            <id>333</id>            <name>Tito</name>            <addresses>                <address>Tito's Street 1</address>                <address>Tito's Street 2</address>                <address>Tito's Street 3</address>                <address>Tito's Street 4</address>            </addresses>        </person>    </persons></table></report>[/code]

I trying to generate a report from above xml. I need to concat list of address element in table 

Expected Result:

NAMEADDRESSES
JohnJohan's Street 1 , Johan's Street 2 , Johan's Street 3
MarkoMarko's Street 1 , Marko's Street 2
TitoTito's Street 1 , Tito's Street 2 , Tito's Street 3 , Tito's Street 4

 

 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...