Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New to the CF scene
    Join Date
    Feb 2010
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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

  • #2
    New to the CF scene
    Join Date
    Apr 2010
    Location
    Lakewood, CO
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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 ...

  • #3
    New to the CF scene
    Join Date
    Feb 2010
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you for your reply.

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

  • #4
    Regular Coder
    Join Date
    Apr 2009
    Posts
    244
    Thanks
    1
    Thanked 20 Times in 20 Posts
    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


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •