Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error converting varchar value "F"

Hello,

I am using Crystal Reports Developer Version 11.0.0.1282 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'

replied

Russell,

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.

Jason

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question