Cannot Generate Crystal or SQL Reports


Please have a competent IT person perform these steps. Make a backup of the registry prior to performing these steps.

If the firm cannot generate reports from Firm Reports or My Reports please do the following to correct the issue:

1

Access the Amicus server

2

Go to Run and type in Regedit

3

Navigate to HKEY_LOCAL_MACHINE\Software\Wow6432Node\ODBC\OBDC.INI\Amicus

ODBC-settings.png

4

Double click the server key to modify it to point to your SQL server and the Amicus instance.

If you have a split install (Amicus on one server and SQL on another) please point to the SQL server.

To check your Amicus instance name login to SQL Management Studio and verify your instance name.

SQL-Mgmt-Studio-Instance.JPG

Add Comment

Rate this article: