Database Connector Error in business object when call the crystal report

[Former Member]

The stored procedure is successful

The report call the stored procedure is successfully, crystal report version is 14.0

Unfortunately it failed when run the report in business object with Database connector error: 42000 ODBC SQL Server Driver Error converting data type to date.

In the stored procedure I already set the dateformat DMY, and default date format in crystal report is also DMY.

thanks

[michael_loop]

Apple,

We will need more details to help with this question.

Can you provide the code for stored procedure, or a trimmed-down version that reproduces the problem?

What is the output from the procedure?

Do you know which output variable is causing the error?

Regards,

Mike Loop
Senior Support Engineer
SAP Product Support