Crystal Reports / Quickbooks

[jillblecher]

I just installed a new server and my Crystal Reports are no longer working. It appears as if the connection between Crystal and Quickbooks may have been severed. I ran the "Configure ODBC" utility through Quickbooks Enterprise 20 and the test is successful.

I think all I need to do is to reestablish the link between Crystal and Quickbooks but I cannot figure out how to do so.

[DellSC]

Which version of Crystal are you using and what version of Windows?

[msundararaja_perumal]

Hello,

1. From Crystal reports, create a new report
2. Open the Database Expert
3. Select Create New Connection
4. Select ODBC (RDO).
5. Select Find File DSN.
6. Select the button next to the File DSN field to locate the file datasource. The QuickBooks file datasource is located in the same folder as your company file. It has the same name as your company file with a 'DSN' extension. Go to the location of your company file and select the DSN file and enter the credentials of the ODBC user you created.

Thanks.