nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Connecting child and parent tags in an XML DataSource

radhikamody

Hi,
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).
 
I need to print the parent tag and its OWN child elements in one table.
 
eg.
<Person>
<Name> Robin </Name>
<Addresses>
<Address>
<Street> 123 </Street>
</Address>
<Address>
<Street> 456 </Street>
</Address>
</Addresses>
</Person>
<Person>
<Name> Percy</Name>
<Addresses>
<Address>
<Street> ABC </Street>
</Address>
<Address>
<Street> DEF </Street>
</Address>
</Addresses>
</Person>
 
I want to have the output as 
 
Robin
123
456
 
Percy
ABC
DEF
 
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.
 
I am attaching my XML and BIRT design.
For every <EserciziECH> I want the corresponding <FasciaCommECHPD2> and so on and so forth. 
 
Is it possible?
 
<div> </div>

Find more posts tagged with

Comments

JFreeman

From my experience, using a Scripted Data Set/Source is going to be one of the better ways to handle complex XML.
 
Take a look at the attached example using the sample "Person" data from your post.
 
If you are going to be frequently deal with complex XML, it may also make sense to create a custom ODA to handle your XML versus using a Scripted Data Set/Source in each report.

radhikamody

<div>I am not able to preview the report you created. The data source greys out the edit option.</div>
<div> </div>
<div>Alos, how do I attach a file to an existing thread like this one?</div>

radhikamody

where can I find the user guide to create a scripted data source and a scripted data set?

JFreeman

Based on the report you attached it looks like you are using BIRT 2.2.2. The example I created was in 4.4.0 which explains why you could not run it. I'm working on recreating the example in 2.2.2, i'll attach it once i'm done.
 
Regarding attaching a file, select the More Reply Options when replying to the thread and there will be an option to attach a file.
 
As for resources on creating a scripted data source/set take a look at these 3 to start:
<ol><li><a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/506-sample-birt-scripted-data-source-example/'>http://developer.actuate.com/community/forum/index.php?/files/file/506-sample-birt-scripted-data-source-example/</a></li>
<li><a data-ipb='nomediaparse' href='http://blogs.actuate.com/use-json-as-a-scripted-data-set/'>http://blogs.actuate.com/use-json-as-a-scripted-data-set/</a></li>
<li><a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/1063-eclipses-birt-scripted-data-set/'>http://developer.actuate.com/community/forum/index.php?/files/file/1063-eclipses-birt-scripted-data-set/</a></li>
</ol>

JFreeman

Attached is the example built for 2.2.2 BIRT.
 
On a side note, I would recommend looking towards upgrading to a newer version of BIRT as 2.2.2 is approaching being 8 years old.

radhikamody

Thank you. I was able to see the script.
Actually we are not using BIRT as an individual software. It is bundled with an Informatica tool that we are using, so we do not have the rights to upgrade to the higher version.
 
I was able to get the child and parent tag relationship working by creating two datasets. A parent dataset with the parent tags, and a child dataset for a child with the child tag and one tag from the parent which will be unique. Add a table in the parent table with the child dataset as the binding. In the visibilty check for the child id and parent id to be not equal. I am attaching my report design for reference.
 
I have a new issue, The rows of the same table get split. So if I have a table with 2 columns, if the last row is printed at the end of the page, it will split that row as two rows with column1 data in one row, and then go onto the next page and create a new row with just column 2 data. I am attaching the PDF for a better picture. Please have a look at page 6, last row. Can you tell me what do I need to set/change this behavior.

radhikamody

Any help on the random page break for the table row will be of great help. Any ideas?

JFreeman

That's a rather strange one. I've not seen something quite like that before.
 
I would try adjusting the cell widths on that row and see if it makes a difference.
 
Also, do you see the same behavior when viewing the report in the Web Viewer?

radhikamody

I tried adjusting the widths and heights, I see the same behavior. 
In web viewer, the page breaks are not visible. It is one long page.