Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Connecting child and parent tags in an XML DataSource
Migrateduser
<p>Hi,</p>
<p>I am using an XML datasource in my report. I have created multiple datasets for each complex tag that can repeat. But the structure of my XML has parent tags (0..n) and child tags (0..n).</p>
<p> </p>
<p>I need to print the parent tag and its OWN child elements in one table.</p>
<p> </p>
<p>eg.</p>
<p><Person></p>
<p><Name> Robin </Name></p>
<p><Addresses></p>
<p><Address></p>
<p><Street> 123 </Street></p>
<p></Address></p>
<p><Address></p>
<p><Street> 456 </Street></p>
<p></Address></p>
<p></Addresses></p>
<p></Person></p>
<p><Person></p>
<p><Name> Percy</Name></p>
<p><Addresses></p>
<p><Address></p>
<p><Street> ABC </Street></p>
<p></Address></p>
<p><Address></p>
<p><Street> DEF </Street></p>
<p></Address></p>
<p></Addresses></p>
<p></Person></p>
<p> </p>
<p>I want to have the output as </p>
<p> </p>
<p>Robin</p>
<p>123</p>
<p>456</p>
<p> </p>
<p>Percy</p>
<p>ABC</p>
<p>DEF</p>
<p> </p>
<p>How do I achieve this? I am sure it is possible, but the join dataset does not work. If I include all the tags in just one dataset I get just the first occurrence of the children tags.</p>
<p> </p>
<p>I am attaching my XML and BIRT design.</p>
<p>For every <EserciziECH> I want the corresponding <FasciaCommECHPD2> and so on and so forth. </p>
<p> </p>
<p>Is it possible?</p>
<p> </p>
<div> </div>
<p> </p>
Find more posts tagged with
Comments
There are no comments yet