<p>Hi,</p>
<p>We have a requirement to design a BIRT report using XML file as input.</p>
<p>The design requirement is such that we have to create 9 data sets and join these to create a final data set holding details for complete set (total 5 joined data sets).</p>
<p> </p>
<p>Report design is using "List" element with grouping on certain field (using final joined data set). There are two repeatable sections added with "Table" (using 2 data sets from 9 normal ones).</p>
<p> </p>
<p>Now, this report is taking more than 30 mins to process 1000 records.</p>
<p> </p>
<p>Based on various discussions, I have also tried to use scripted data sets, however even those need to parse XML multiple times and taking approx. 26 mins to process same set of 1000 records.</p>
<p> </p>
<p>Attaching sample data and report design files. </p>
<p> </p>
<p>Kindly please suggest if there are any alternate to improve performance?</p>
<p> </p>
<p> </p>
<p>Thanks,</p>
<p>
