Hi all,
Using VS2010 and Crystal Reports 13.0.2000.0. We design the report connecting to the SQL Server tables, but in the application, when the report is executed, we reassign the report datasources to DataTable objects in the application. In the application, the crystal reports will never directly access the SQL server.
Here's a short sample of code:
GLRptDetailTrialBalance rpt = new GLRptDetailTrialBalance();
rpt.Database.Tables["GLAccount"].SetDataSource((DataTable)ChartOfAccounts.Coa.CoaList.GLAccount);
rpt.Database.Tables["Branch"].SetDataSource((DataTable)ChartOfAccounts.Coa.CoaList.Branch);
This is working fine, except that the first table that gets reassigned will pause a long time (> 1 minute) if the SQL server used in developing the report is not available. It's as if it is still trying to connect to the original data source prior to reassigning to the new data source. The subsequent table reassignments will happen quickly after the initial one as if the system knows not to try searching for the original data source again for the remaining tables.
Does anyone know how to eliminate this pause or have any suggestions?
TIA
Quinton