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

Table Column Binding displays only 1 record

keerthink

Hi,
 
I have developed a couple of simple reports in Birt RCP designer 4.2.2 now, but this is the first time I am having this issue. 
My table in the report wont iterate over all the rows in the XML. It only displays one row. Even under Preview Results for the Data Set, I am able to see just the first row even though i had set it to show 10 in the first step of creating a Data Set. 
 
I tried importing the XML to a spreadsheet to make sure the elements are all correct, and the import works just fine.
 
Thanks for your help.

Find more posts tagged with

Comments

JFreeman

This may have to do with the structure of the XML and how the data set is configured to use the data. I have encountered situations previously where the structure of the XML is such that the out of the box ODA cannot handle it properly for the desired use case.
 
Can you attach a sample of the XML you are using for the data source and a sample report design that uses the XML that demonstrates the issue?

keerthink

Yes.. here is a sample report design. I am not able to attach the XML. I get an upload error. 
Why is that?
 
here is the link to it
<a data-ipb='nomediaparse' href='https://www.dropbox.com/s/55bjvjevzejl2fb/sampleXMLforBirt.xml?dl=0'>https://www.dropbox.com/s/55bjvjevzejl2fb/sampleXMLforBirt.xml?dl=0</a>
 
Thanks!

JFreeman

The reason you were only getting 1 row returned has to do with how you have the Row mapping configured. You have the Row Mapping set at the top level of the XML in the Data Set. As there is only 1 report node in the XML, it see this as the only row to parse.
 
Take a look at the attached modified version of your sampleReport. I have changed the Row Mapping to /report/records/record/titles/title so it will parse for each title node within the XML. After this change, I have also recreated the column mapping to the XPath for the columns is accurate for the new Row Mapping.
 
With these changes, a row is created for all 6 titles.

keerthink

I truly appreciate your help.
Thank you

JFreeman

You're welcome.
Let us know if you have any additional questions.