Am new to crystal report, using 8.0. I have lost two days trying to solve the following problem. if any one can give a solution will be really greatfull.

i have created a simple report with VB using the RDC. am trying to connect to a oracle database. report is running fine, but problems are

1. the data is not getting updated, even after settting save discard data - False.
2. On pressing refresh button giving error, "Server not yet been opened"

I will be realy greatefull if some can give a soution.... am fed up !

The code am using is as follows

Dim Report As New CrystalReport2

Private Sub Form_Load()
Screen.MousePointer = vbHourglass
CRViewer1.ReportSource = Report
While CRViewer1.IsBusy
Screen.MousePointer = vbDefault
End Sub

Private Sub Form_Resize()
CRViewer1.Top = 0
CRViewer1.Left = 0
CRViewer1.Height = ScaleHeight
CRViewer1.Width = ScaleWidth
End Sub