Crystal Reports Error "Failed to retrieve from database {Database Vendor Code: 512}

Hello,

I am getting an error when running a Crystal Report.

Failed to retireve data from database.
Details: 2100 [Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=, >, >=, or when the subquery is used as an expression. [Database Vendor Code: 512]

I have not seen this before, so do not know where to start to repair the fault.

Can anyone help?

Kwirky :D

A few details are needed:

Version of Crystal
SQL code sent to CRAXDRT(if any)
SQL code accessed by Crystal


This would be a starting point ...

Thank you for your reply.

The only answer I know is that we are using Crystal Reports XI.

Hey Kwirky,

As sqlkahuna mentioned, you have to provide whatever sql is being used. The error is pretty clear. Somewhere you have an inner select statement that should return only one value that is used as a comparison inside some condition, and instead it returns multiple values.

Mike