Skip to Content
Former Member
Feb 14, 2012 at 04:11 PM

Crstal Reports: "Failed to retrieve data from the database"


Running a report in crystal report from SAP 8.81 using the following parameters: CardCode, GroupCode, Date gives the following error: "Failed to retrieve data from the database" "Conversion failed when to converting the nvarchar value to data type int 12/31/2005 [Database vendor code: 245] ".

The store procedure in SQL Server executes smoothly and If you run the report with the date = 12/31/2005 in the parameter also returns expected results.