Custom Reports and Binding Errors

Occasionally, after migrating Acctivate with CYMA to a new server, the custom reports can run into errors when attempting to print. After verifying that the custom reports are correctly linked in the Reports section of Configuration Manager, try to print the custom report in question.

If you encounter the following error or something similar:

Crystal Report Viewer
Failed to retrieve data from the database.
Details: ADO Error Code: 0x80040e14
Source: Microsoft OLE DB Provider for SQL Server
Description: Could not use view or function ‘ACCTivate_Demo.dbo.Invoice’ because of binding errors.
SQL State: 42000
Native Error: 4413 [Database Vendor Code: 4413 ]

You may encounter it twice. Once before showing the preview (which will not appear) and following the click of the Print button on the preview window. After closing the error for the second time, Acctivate may crash.

Run Verify Database from within Database Maintenance. After a successful verify, attempt to print once again. The issue should be resolved.

Posted in Reports - Last modified on June 10, 2019
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support ticket.