Fusseltier
August 27th, 2004, 06:34 AM
Hi all,
I just installed a second machine for develloping, and put my VB (6.0 Enterprise SP4) Project there. I also installed CR 8.5, so the two machines should be identically.
(Win2K SP4, VB6 Ent. SP4, CR 8.5)
But viewing a report on the new machine takes FOREVER, even if there is only one record per RS. On the "old" machine, the report displays in < 1 Sec, on the new machine I have to wait > 45 sec...
Same Code, Same Report, Same Database, Same Query-Results....
Here's my code:
Public Report As New crep_order
[...]
[...]
Here I execute my querys
[...]
[...]
With Report
.VerifyOnEveryPrint = False
.database.SetDataSource reprs, 3, 1
.database.SetDataSource reprs1, 3, 2
.database.SetDataSource reprs2, 3, 3
.database.SetDataSource reprs3, 3, 4
.database.SetDataSource reprs4, 3, 5
.database.SetDataSource reprs5, 3, 6
.database.SetDataSource reprs6, 3, 7
.database.SetDataSource reprs7, 3, 8
.database.SetDataSource reprs8, 3, 9
.database.SetDataSource reprs9, 3, 10
End With
Screen.MousePointer = vbHourglass
CRViewer1.Zoom (1)
CRViewer1.ReportSource = Report
CRViewer1.ViewReport
Everything works like a charm (the querys are getting executed VERY fast, and correctly of course...), the problem arises when "CRViewer1.ViewReport" is executed, this single command takes nearly a minute....
On my old machine (which is identical to my new one concerning OS+Patchlevel, VB+Patchlevel and CR) the whole thing is lightning fast.... ???
This problem concerns ALL reports in the project... on the old machine theyre fast, on the new one slow...
Any ideas ?
Thx in advance for helping a newb like me :)
Fusseltier
I just installed a second machine for develloping, and put my VB (6.0 Enterprise SP4) Project there. I also installed CR 8.5, so the two machines should be identically.
(Win2K SP4, VB6 Ent. SP4, CR 8.5)
But viewing a report on the new machine takes FOREVER, even if there is only one record per RS. On the "old" machine, the report displays in < 1 Sec, on the new machine I have to wait > 45 sec...
Same Code, Same Report, Same Database, Same Query-Results....
Here's my code:
Public Report As New crep_order
[...]
[...]
Here I execute my querys
[...]
[...]
With Report
.VerifyOnEveryPrint = False
.database.SetDataSource reprs, 3, 1
.database.SetDataSource reprs1, 3, 2
.database.SetDataSource reprs2, 3, 3
.database.SetDataSource reprs3, 3, 4
.database.SetDataSource reprs4, 3, 5
.database.SetDataSource reprs5, 3, 6
.database.SetDataSource reprs6, 3, 7
.database.SetDataSource reprs7, 3, 8
.database.SetDataSource reprs8, 3, 9
.database.SetDataSource reprs9, 3, 10
End With
Screen.MousePointer = vbHourglass
CRViewer1.Zoom (1)
CRViewer1.ReportSource = Report
CRViewer1.ViewReport
Everything works like a charm (the querys are getting executed VERY fast, and correctly of course...), the problem arises when "CRViewer1.ViewReport" is executed, this single command takes nearly a minute....
On my old machine (which is identical to my new one concerning OS+Patchlevel, VB+Patchlevel and CR) the whole thing is lightning fast.... ???
This problem concerns ALL reports in the project... on the old machine theyre fast, on the new one slow...
Any ideas ?
Thx in advance for helping a newb like me :)
Fusseltier