...

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



Kwirky
04-16-2010, 03:14 AM
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

sqlkahuna
04-16-2010, 06:31 AM
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 ...

Kwirky
04-16-2010, 07:33 AM
Thank you for your reply.

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

Mike_O
04-21-2010, 05:40 PM
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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum