I'm hoping that Ludek or someone out there can offer some advice or help troubleshoot a critical issue we have encountered since upgrading from Crystal Reports 9 to Crystal Reports2008.
We have a VB.NET 2008 application running on Microsoft .NET 3.5. We are using Crystal Reports 2008 runtime, service pack 3 -- using the CrystalDecisions.Windows.Forms.CrystalReportViewer in the app to view reports. In the GAC on all our client computers, we have versions 12.0.1100.0 and 12.0.2000.0 of CrystalDecisions.CrystalReports.Engine, CrystalDecisions.Shared, and CrystalDecisions.Windows.Forms.
These reports are created using Crystal Reports 2008 Developer, and they run against Oracle 11g databases, using the Oracle Provider for OLEDB as the connection method.
In our code, we use the ConnectionInfo.SetConnection method to pass login information at runtime, as follows:
'-- Set database connection info for the main report For Each oConnectionInfo In oCrystalReport.DataSourceConnections oConnectionInfo.SetConnection(gsDBDataSource, "", gsDBUserID, gsDBPassword) Next oConnectionInfo '-- Set database connection info for each subreport For Each oSubreport In oCrystalReport.Subreports For Each oConnectionInfo In oSubreport.DataSourceConnections oConnectionInfo.SetConnection(gsDBDataSource, "", gsDBUserID, gsDBPassword) Next oConnectionInfo Next oSubreport
The code above runs quickly, and without error. The problem is that, aside from a very specific circumstance, the reports run extremely slow. After this code, the CrystalReportViewer runs the report and does whatever data-retrieval, etc. it needs to do:
oReportViewer.ReportSource = oCrystalReport oReportViewer.Zoom(1) '-- Page Width System.Windows.Forms.Application.DoEvents()
The problem comes...please continue on this thread for readability Question Discarded
Edited by: Sciences on Aug 24, 2010 9:34 PM