Critical issue since upgrading from CR9 to CR2008

37 Views

Hi there,

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