Dear Experts
We are having a problem with Crystal Reports 2008 SP2 when attempting to generate the report to stored procedure using the u201CSQL Server Native Client 10.0u201D provider. we use a stored procedure that takes a date parameter the following error is produced:
Database Connector Error: 'ADO Error Code: 0x
Source: Microsoft SQL Server Native Client 10.0
Description: Incorrect syntax near the keyword 'CONVERT'.
SQL State: 42000
Native Error: 156 Database Vendor Code: 156 '
We are using SQL Server 2008 and Crystal Reports 2008.
We are upgrading SAP from 2007B to 8.81 Patch - 06. all the crystel reports are generated in SAP 2007B. while generating the crystel report in 8.81 we are having the above mentioned issue let me help to solve the issue asap
Regards
Shamseer