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?