<p>Hi,<br>
I created a report using BIRT. In that report, for a single row i have multiple values.<br>
For Ex.</p>
<p> </p>
<p>
</p>
<p>Country Region Value</p>
<p>
</p>
<p>India 1 100</p>
<p> 2 200</p>
<p> 3 400</p>
<p>
</p>
<p>US 1 300</p>
<p> 2 599</p>
<p>
</p>
<p> For this I am using the below condition:</p>
<p> </p>
<p><span style="color:#800000;">LISTAGG(NVL(to_char(Region_No),''),chr(13) || chr(10)) WITHIN GROUP(ORDER BY Country)AS Region_No,<br>
LISTAGG(NVL(to_char(value),''),chr(13) || chr(10)) WITHIN GROUP(ORDER BY Country) AS value</span></p>
<p> </p>
<p>and it is showing blank only if the null is coming in the middle like,</p>
<p>if the value of Region 2 or 3 is null means, i am getting the report correctly.</p>
<p> </p>
<p>But the problem is, if the value of region 1 is null, it is not showing blank.its shows next region's value</p>
<p>Please help me to resolve this issue.</p>
