<p>Hi all,</p>
<p> </p>
<p>I am new to birt. I need to create a report for the xml that have multiple same tags.When ever I try to create a table, birt reads only first tag and leaves the remains tags. What should I do, so that birt could all the tags?</p>
<p> </p>
<p>XML File :</p>
<p><span style="color:rgb(186,45,162);font-family:Menlo;font-size:11px;"><?xml version=</span><span style="font-family:Menlo;font-size:11px;color:rgb(209,47,27);">"1.0"</span><span style="color:rgb(186,45,162);font-family:Menlo;font-size:11px;"> encoding=</span><span style="font-family:Menlo;font-size:11px;color:rgb(209,47,27);">"ISO-8859-1"</span><span style="color:rgb(186,45,162);font-family:Menlo;font-size:11px;">?></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(186,45,162);"><span><school></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(186,45,162);"><span style="color:#000000;"> </span><span><class></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(186,45,162);"><span style="color:#000000;"> </span><span><student></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(0,0,0);"><span> </span><span style="color:#ba2da2;"><id></span><span> abc </span><span style="color:#ba2da2;"></id></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(186,45,162);"><span style="color:#000000;"> </span><span></student></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(0,0,0);"><span> </span><span style="color:#ba2da2;"><course></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(0,0,0);"><span> </span><span style="color:#ba2da2;"><title></span><span>Maths</span><span style="color:#ba2da2;"></title></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(0,0,0);"><span> </span><span style="color:#ba2da2;"><score></span><span> 80 </span><span style="color:#ba2da2;"></score></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(186,45,162);"><span style="color:#000000;"> </span><span></course></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(0,0,0);"><span> </span><span style="color:#ba2da2;"><course></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(0,0,0);"><span> </span><span style="color:#ba2da2;"><title></span><span>Art</span><span style="color:#ba2da2;"></title></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(0,0,0);"><span> </span><span style="color:#ba2da2;"><score></span><span>100</span><span style="color:#ba2da2;"></score></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(186,45,162);"><span style="color:#000000;"> </span><span></course></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(0,0,0);"><span> </span><span style="color:#ba2da2;"><course></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(0,0,0);"><span> </span><span style="color:#ba2da2;"><title></span><span>physics</span><span style="color:#ba2da2;"></title></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(0,0,0);"><span> </span><span style="color:#ba2da2;"><score></span><span> 80</span><span style="color:#ba2da2;"></score></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(186,45,162);"><span style="color:#000000;"> </span><span></course></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(0,0,0);"><span> </span><span style="color:#ba2da2;"><student></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(0,0,0);"><span> </span><span style="color:#ba2da2;"><id></span><span> efg </span><span style="color:#ba2da2;"></id></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(186,45,162);"><span style="color:#000000;"> </span><span></student></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(0,0,0);"><span> </span><span style="color:#ba2da2;"><course></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(0,0,0);"><span> </span><span style="color:#ba2da2;"><title></span><span> Maths</span><span style="color:#ba2da2;"></title></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(0,0,0);"><span> </span><span style="color:#ba2da2;"><score></span><span> 70 </span><span style="color:#ba2da2;"></score></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(186,45,162);"><span style="color:#000000;"> </span><span></course></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(0,0,0);"><span> </span><span style="color:#ba2da2;"><course></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(0,0,0);"><span> </span><span style="color:#ba2da2;"><title></span><span>Art</span><span style="color:#ba2da2;"></title></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(186,45,162);"><span style="color:#000000;"> </span><span><score></span><span style="color:#000000;">90</span><span></score></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(186,45,162);"><span style="color:#000000;"> </span><span></course></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(0,0,0);"><span> </span><span style="color:#ba2da2;"><course></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(0,0,0);"><span> </span><span style="color:#ba2da2;"><title></span><span>physics</span><span style="color:#ba2da2;"></title></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(0,0,0);"><span> </span><span style="color:#ba2da2;"><score></span><span> 60</span><span style="color:#ba2da2;"></score></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(186,45,162);"><span style="color:#000000;"> </span><span></course></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(186,45,162);"><span style="color:#000000;"> </span><span></class></span></p>
<p style="font-size:11px;font-family:Menlo;color:rgb(186,45,162);"><span></school></span></p>
<div> </div>
<div>In the above XML file, I want to create a report that consists of total courses and related scores for each student. But when I try in Birt I am getting only first student "abc" and the first course "Maths" are getting printed. </div>
<div> </div>
<div>Obtained Output:</div>
<div> </div>
<div>id title1 Score1</div>
<div>abc Maths 80 </div>
<div> </div>
<div>I need output as</div>
<div> </div>
<div>id title1 Score1 title2 score2 title3 score3</div>
<div>abc Maths 80 Art 100 physics 80 </div>
<div>efg Maths 70 Art 90 physics 60 </div>
<div> </div>
<div>I have attached the .rptdesign file. </div>
<div> </div>
<div>Please guide me through the process.</div>
