Cast String to Number in BIRT

kpeters

<p>There are a couple of options in BIRT when using CSV as a data source and you want to cast a String as a number in order to do further formating (currency, etc.):</p><ol><li>Double-click on the data field and select Decimal from the "Data Type" dropdown. Then, you will be able to format via the "Format Number" property of the data.</li><li>You can set the data type in the second row of the CSV file. Make sure that you set the flag on the data source which indicates to use the second row as a data type. Then, you will be able to format via the "Format Number" property of the data.</li></ol>