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; } } }

Issues with XML Data source

ushank

I have to use an XML as a data source in my report. 
My xml has multiple child tags with the same name(ex. <author>). Please refer the XML pasted below.
 
<?xml version="1.0" encoding="ISO-8859-1"?>
<BookStore> 
<Book> 
<title>History</title> 
<author>Tom</author> 
<copies>10;</copies> 
<price>80</price> 
</Book>
<Book> 
<title>Basic Mathematics</title> 
<author>Roy</author> 
<author>Jon</author> 
<copies>5</copies> 
<price>100</price> 
</Book>
<Book> 
<title>Java</title> 
<author>Harry</author> 
<author>Potter</author> 
<copies>6</copies> 
<price>100</price> 
</Book> 
</BookStore>
 
I have added a XML data source and a dataset in my report. I have made the following mappings in my XML dataset.
Row mapping: /BookStore/Book 
Column Mapping: Mapped all the child tags

In the data set, I am getting three records, one for each of the <Book> tag. But, the author column contains the value of only the first tag.For example, the second record contains only "Roy". The second <author> tag is not being recognised by the BIRT. I need to get both "Roy" & "Jon" from the second <Book> element. And, I need to get both "Harry" & "Potter" from the third <Book> element. Can you please let me know how to get all the values from tags with the same name into the dataset.
I have attached the rpt design file and xml source I'm using.
Appreciate your help. Please let me know how to design the XML dataset.

Find more posts tagged with

Magellan BI & Reporting

Comments

ushank

rptdesign file

JFreeman

The out of the box ODA for XML has limitations when it comes to more complex XML such as situations like this where you can have a varying number of nodes with the same name.
 
Instead you can create a scripted data source/set and write the needed logic to parse the XML into your desired rows.
 
Take a look at the attached modified version of your sample Book report I have attached with an example of doing this with a scripted data source/set.

ushank

Hey Jesse, you are my saviour.. The code helped me nail the issue I was facing. Thanks a lot for your help. Was really busy over the past few weeks. Just realised that I did not even say a thanks to you. Thanks a ton for your timely response.

JFreeman

You're welcome, I'm glad I could be of assistance.
Thank you for taking the time to confirm this helped resolve the issue.
 
Let us know if you have additional questions in the future.

Sandy Wishpond

Along the same lines is it possible to form rows (rather than appending the data together), eg:
<?xml version="1.0" encoding="ISO-8859-1"?>
<BookStore> 
<Book> 
<title>History</title>
 <title>Science</title> 
<author>Tom</author> 
<author>Kevin</author> 
</Book>
<BookStore>
 
then is it possible to display data under a table as:
Book Title Book Author
History Tom
Science Kevin