multi-Instance field Need Single value

dharmapu.ajay

<p style="font-size:15px;color:rgb(34,36,38);font-family:Arial, 'Helvetica Neue', Helvetica, sans-serif;">I am creating a data set from primary and secondary data source. I am able to get data but I want to alter the data in required format. Data source from a XML file.</p>
<p style="font-size:15px;color:rgb(34,36,38);font-family:Arial, 'Helvetica Neue', Helvetica, sans-serif;">Eg: I am getting:</p>
<p>01-Jan-2016<br>
01-Apr-2016</p>
<p style="font-size:15px;color:rgb(34,36,38);font-family:Arial, 'Helvetica Neue', Helvetica, sans-serif;">Now I only want 01-Apr-2016.</p>

icirillo

<p>Hi, you may create a computed column which contains the formatted values you need, for example. I have attached a sample report. Otherwise you may consider looking at <a data-ipb='nomediaparse' href='http://birtworld.blogspot.ch/2011/02/birt-formatting-numbers-and-dates.html'>http://birtworld.blogspot.ch/2011/02/birt-formatting-numbers-and-dates.html</a></p&gt;