The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Crystal Reports XI Update Errors
Posted: 11 Jan 07 12:01 PM
|
fiogf49gjkf0d I am trying to update our reports from 8.5 to XI through the Architect and I'm have an issue with reports that use a stored procedure as the database. When in the client and trying to run a report that has not been update I get this error:
Failed to retrieve data from the database.
Details: [Database Vendor Code: 858861104 ]
When I update a customer report in Architect that is using a stored procedure I am able to set defaults but when I refresh the report I enter the parameters, click OK and then I get this message:
Database Connect Error: 'ADO Error Code: 0x
Source: SalesLogix OLE DB Provider
Description: Incorrect syntax near the keyword 'CONVERT'.'
We are planning on upgrading production next week and these reports have to work. Has anyone run into this or more importantly, know a solution/fix?
Thanks,
John G. |
|
|
| |
| |
| |
|
Re: Crystal Reports XI Update Errors
Posted: 12 Jan 07 6:31 AM
|
fiogf49gjkf0d Yep, 6.2 SP1. My usual method of pulling datasets for Crystal Reports has always been through a stored procedure or view.
John G. |
|
|
|