Error converting varchar value "F"
I am using Crystal Reports Developer Version 220.127.116.112 and we encountered an issue on two separate reports relating to this issue.
The error message is:
Failed to retrieve data from the Database
ADO Error Code: 0x8004De07
Microsoft OLE DB Provider for SQL Server
Syntax error converting the varchar value "F" to a column of data type int.
SQL State 22018
Native error 245 Database error 245
Are you able to provide some assistance please
The error occurred only 'suddenly' on 'business critical' reports that have been operating without isue for 'quite' some time on Crystal Reports 9 and we could not resolve it by restoring from old file tape backups, hence why it is 'alarming'
Jason Long replied
That is telling you that you are trying to convert a VARCHAR data type to an INT data type. The problem is that SQL Server can't CAST or CONVERT letters into numbers.
You will need to filter out any rows that have letters in the field you are trying to convert. before converting.