Crystal Viewer Problem (I think)
We have a Windows app going against a SQL Server 2000 database.
We use the .NET version of Crystal Reports.
On .NET forms the user selects various criteria.
We than use the following code when user clicks on “Run Report” button.
Dim my1559E As New cr1559E()
Dim myCrystalViewerIGARS As New frmCrystalViewerIGARS()
Dim mySelections As String = ""
my1559E.RecordSelectionFormula = ""
we build the record selection string “mySelections” here depending on selected items on the form
my1559E.RecordSelectionFormula = mySelections
myCrystalViewerIGARS.crvIGARS.ReportSource = my1559E
All of this works, but some reports take a lot of time and the “CrystalViewer” screen has popped up and is executing the report with a blank “CrystalViewer” screen being displayed until report finishes and then it appears inside the “CrystalViewer” screen.
Our question is this: If the user minimizes this “CrystalViewer” screen while the report is running to work on something else while the report is executing, the application hangs and never comes back. Is there some way for a long report to run while other work is being done on the workstation?