Conversion failed when converting the varchar value 'NA' to data type int

avasquez

<p>Hi I need help , how do I fix this error?</p>
<p><b><span>org.eclipse.birt.report.engine.api.EngineException: Cannot fetch the next data row. org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot move down to next row in the result set. SQL error #1:Conversion failed when converting the varchar value 'NA' to data type int. ; com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting the varchar value 'NA' to data type int.</span></b></p>
<p>
Thanks from Panama</p>
<p> </p>
<p> </p>

mwilliams

So, in your database, you have NA as a value in an int field? Have you tried writing an expression in your sql to return a 0 instead of 'NA'?<br><br><a data-ipb='nomediaparse' href='https://msdn.microsoft.com/en-us/library/ms182717.aspx'>https://msdn.microsoft.com/en-us/library/ms182717.aspx</a&gt;