Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value [tax claim ref] to data type int. Native error:245

Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting the varchar value [tax claim number] to data type int. Native error:245 when running R68 report (UK version)

Download and install the latest version and patch, if applicable. 

Alternative Solutions:

If error occurs when R68 report underlining query is a constituent query:
  • Create a Gift Query with same filters as the constituent query and use this with the report


If error occurs when no underlining query or using a gift query:
  • Create a gift query with criteria Tax Claim Refund Number blank, save and close query
  • On the General tab of the R68 report, include selected records and select query created in step 1
  • Run report
     

Environment

 7.91.5056.14 ; 7.91.5056.10
 7.93.5782

Was this article helpful?