Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
shows only 1 row from XML data source
alexlebedew
<p>hi i am new in birt.</p>
<p>i have a problem with displaying XML data set.</p>
<p>with excel data sources it works fine.</p>
<p> </p>
<p>simple xml is attached.</p>
<p>i select it in data sets , i check row mapping xpath /tests</p>
<p>column mapping i choose all elements.</p>
<p>when i click on preview and also in generated table it shows only 1st row. but it has 2 rows.</p>
<p> </p>
<p>is my xml file not correct or i do wrong settings in birt?</p>
<p> </p>
<p>when i open xml in excel it shows 2 rows correctly. strange</p>
<p> </p>
<p>thank you for help<br>
</p>
Find more posts tagged with
Comments
Clement Wong
<p>Hi there,</p>
<p> </p>
<p>I tested using OS BIRT 4.3.2 and commercial BIRT Designer Professional iHub3 against your sample XML file, and both show 2 rows of data.</p>
<p> </p>
<p>Attached is the design. Please update the file location of the XML accordingly in the Data Source.</p>
<p> </p>
<p>What version of BIRT are you using?</p>
alexlebedew
<blockquote class="ipsBlockquote" data-author="Clement Wong" data-cid="129846" data-time="1406938472">
<div>
<p>Hi there,</p>
<p> </p>
<p>I tested using OS BIRT 4.3.2 and commercial BIRT Designer Professional iHub3 against your sample XML file, and both show 2 rows of data.</p>
<p> </p>
<p>Attached is the design. Please update the file location of the XML accordingly in the Data Source.</p>
<p> </p>
<p>What version of BIRT are you using?</p>
</div>
</blockquote>
<p>thank you. i have this one; <span>birt-rcp-report-designer-4_4_0-20140611.zip</span></p>
<p><span>and i create table over designer.</span></p>
<p> </p>
<p><span>to use your code i think i need to install API </span>Latest BIRT Runtime Release Build: 4.4.0</p>
alexlebedew
<p>thank you it works. i had problem with xpath.</p>
<p>i selected row mapping: /tests</p>
<p>column mapping: /test/rootpath</p>
<p> </p>
<p>you selected: row mapping /tests/test</p>
<p>column mapping /rootpath</p>