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. |