Nested Tables from XML Datasource

[m.rosetti]

Hi,

I'm quite new to Jasper and I'm facing a blocking problem.

I have an XML source like this:

<items> <item>  <name>John</name>  <activities>   <activity number="1">First activity</activity>   <activity number="2">Second activity</activity>   <activity number="3">Third activity</activity>  </activities>  <durations>   <duration number="1">1 hour</duration>   <duration number="2">1 day</duration>   <duration number="3">2 days</duration>  </durations>  <descriptions>   <description number="1">something short</description>   <description number="2"></description>   <description number="3">something long</description>  </descriptions> </item><item>  <name>Paul</name>  <activities>  <activity number="1">Second activity</activity>  <activity number="2">Another activity</activity> </activities>  <durations>  <duration number="1">2 days</duration>  <duration number="2">2 hours</duration>  </durations>  <descriptions>   <description number="1"/>  <description number="2"/> </descriptions> </item><item>.....</item> </items>

I need to produce a table grouped like this

Name	Activity Name	Duration	Description
John	First activity	1 hour	something short
	Second activity	1 day
	Third activity	2 days	something long
Paul	Second activity	2 days
	Another activity	2 hours

but I cannot find a way to group activity details (activity name, duration, description) to act like rows.

Is there a way to handle this completely inside a single jrxml file without changing XML source structure?

 

Please help,

-MR