Crystal Reports (w/Sub Reports) Exporting Failed

Question

Hello All,

My company has a web application that gets app settings for users and places them in the database (Spread throughout 4 separate databases).  We are using .NET with SQL server 2005 and Crystal Reports 11.5.  Im using the Crystal Reports application to generates the reports.

For support purposes, I need to create a configuration report which basically pulls all the information from the tables and displays it in the report with pretty formatting.  Here is the issue:  Crystal reports only allows one database per report.  Plus, each table has a differing number of columns, therefore, I created sub reports for each of the tables and added them to the main report.  This allows for access to all 4 databases and allows me to format them the way that I want.  However, when the web app generates the report and attempts to export it in the users preferred format, the report bombs and give me a "Database Logon Failed" error.

Whats crazy is that occasionally it will work and I can generate and view the report, but most of the time it crashes.  Also, it goes though and sets all the connections to the reports just fine, it just doesn't like to export it.

Note:  Once the report is only accessing one database it starts to work again.

Does anyone know how to fix this or has experienced this before?  I would really hate to have support generate 4 separate reports and I have been bashing my head in for days!



Thanks in advance!