<p>Hi,</p>
<p> </p>
<p>I'm trying to concatenate two elements using aggregation. But i want to add a condition to concatenate rows block wise. Kindly look into below xml snippet:</p>
<p> </p>
<div>
<pre class="_prettyXprint">
<rootTag>
<identifier>
<C.1.9.1.r.1>Link ID 1</C.1.9.1.r.1>
<C.1.9.1.r.2>001</C.1.9.1.r.2>
<identifier-count>0</identifier-count>
</identifier>
<identifier>
<C.1.9.1.r.1>Link ID 2</C.1.9.1.r.1>
<C.1.9.1.r.2>002</C.1.9.1.r.2>
<identifier-count>0</identifier-count>
</identifier>
<rootTag-count>0</rootTag-count>
<rootTag>
<rootTag>
<identifier>
<C.1.9.1.r.1>Link ID 3</C.1.9.1.r.1>
<C.1.9.1.r.2>003</C.1.9.1.r.2>
<identifier-count>1</identifier-count>
</identifier>
<identifier>
<C.1.9.1.r.1>Link ID 4</C.1.9.1.r.1>
<C.1.9.1.r.2>004</C.1.9.1.r.2>
<identifier-count>1</identifier-count>
</identifier>
<rootTag-count>1</rootTag-count>
<rootTag></pre>
</div>
<p>I need output in the following way - </p>
<p> </p>
<p><strong>In page 1 of the report : Link ID 1/001, Link ID 2/002</strong></p>
<div> </div>
<div><strong>In page 2 of the report: Link ID 3/003, Link ID 4/004</strong></div>
<div> </div>
<div>Using the aggregations concatenate i'm able to combine C.1.9.1.r.1 and C.1.9.1.r.2 tags with appropriate delimeters, but i want to filter out based on <rootTag-count> and <identifier-count> value so that in 1st page identifier items with rootTag-count as 0 is displayed and in 2nd page identifier items with rootTag-count as 1 is displayed.</div>
<div> </div>
<div>I'm not able to use the filter option in aggregation window in the above way.. <br>
can anybody kindly help me.. I'm using BIRT 4.4</div>
<div> </div>
<div>Thank you</div>
