Error converting varchar value "F"

[Former Member]

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'

[Former Member · Accepted solution]

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

[Former Member]

sounds like the table data type on that columns differs from the type you trying to convert to.

where is your conversion on the sql sp or in the report?