Skip to Content
0
Former Member
Jul 21, 2008 at 03:04 PM

Multiple SQL Databases

154 Views

I need to report on data from 2 separate SQL databases.

I can select the tables, link them, and select fields. But as soon as I preview the data, Crystal Reports just closes without any error messages. I have tried a variety of links.

I have tried this using the database expert, and have also tried to use the "add command" option to enter a sql query, but neither works.

This report used to work fine in a test environment, but now fails in a live environment. Nothing has changed in the database configuration.

Can anyone shed some light onto what is going on here?