Refresh method of viewer control (CLOSED)

[divined]

Hello everybody

I`ve initialized and displayed an embedded Crystal Reports report in my application using the code below.

Private Sub LinkViewerToReport()
 
  CrystalReport_listaEtairiwn.Database.SetDataSource rsListaEtairiwn, 3, 1
  
  Set p1 = CrystalReport_listaEtairiwn.ParameterFields.GetItemByName("Title")
  p1.AddCurrentValue (rsYphresia.Fields("Yphresia").Value)
  
  CrystalActiveXReportViewer1.ReportSource = CrystalReport_listaEtairiwn
  
  CrystalActiveXReportViewer1.ViewReport
End Sub

In the Activate event of the form I call the viewer control`s Refresh function. When this occurs the viewer control no longer holds the parameter field value I had passed it. Also the recordset remains unchanged, when I have now deleted a record or two.
Am I missing something?

thx, in advance

George Papadopoulos

[divined]

I think that the problem is that the embedded Visual Basic report seems to have cached the first recordset I gave it. Does anybody have any idea?

[divined]

The only way around I found is to make the report viewer form modal. Then when the form is closed I also unload the embedded report designer. This is the only way I could get the report to dynamically update the recordset.