We have an application that we migrated from Visual Basic 6.0 to Visual Studio.Net 2008 Professional using the migration wizard. The app contains 540 forms. We used Component One's True DBGrid 8.0 in the VB6 app, but the migration tool did not migrate those grids. The migration wizard replaced them all with empty, unformatted, unbound VB.Net data grids. So we had to delete the unformatted data grids and rebuild 98 True DB grids in the app. The app uses SQL Server 2005 for stored databases and a mixture of SQL Server and MS Access tables as the underlying table for grids and as the input tables for Crystal Reports.
The problem we are having at the moment is as follows: If we open the app and go to an application function that uses the Crystal Report Viewer - like a simple 20-line table listing - the report is generated in a reasonable period of time considering that it is the first time the report (or any report) was generated in this session. If we press the printer icon to print the report, printer selection is very slow to pop up and the printing of the one page report is also very slow. If we then go back and request the same report again, the report takes longer to generate and printing (if it works) is even slower than it was on the first request. Screen painting of the menu screen is normally very fast, but is now very slow and fragmented. If we try a third time, we never even get to request the report. the app hangs as soon as we click on the menu icon to open the screen.
The same thing happens if we try to switch from one Crystal Report request to another while in the same session. We end up having to reboot the PC to get it back up and running. There is no way to cancel the task (task manager is non-responsive).
The CPU utilization is always at 100% as soon as the app is started and remains at 100% throughout the session.
We also tried the same app under VS.Net 2005 - similar results.
We are now using Crystal Reports 2008. We have had the exact same problem with CR 10, XI, and X1 R2.
We are running VS.Net 2008 Professional with the SP1 Beta installed and MS.Net Framework 3.5 with SP1 Beta installed as well.
The reports are generated and printed quickly and correctly directly from CR 2008 - the problems only occur when generated from the VB app.
The app works perfectly under VB6/SQL Server 2000 and CR 10.
Any thoughts or suggestions on how to make the Crystal Viewer work properly and repeatedly?