Hi
I am using VB6,crystal report 9 and SQL server 2000,I have a command button that displays the report inside crystal report viewer,but every time i need to display a report,the crystal viewer displays to me the last report so i need to press on refresh to view the current report.
I tried in my VB6 code the following code to make the refresh automatic but it didn't work

VB Code:
  1. Rs.Open str2, cnn, adOpenStatic, adLockOptimistic

  2. Set oApp = New CRAXDRT.Application

  3.     Set oReport = oApp.OpenReport(App.Path & "\Report2.rpt", 1)

  4.     oReport.Database.SetDataSource Rs, 3, 1

  5.     crvMyCRViewer.ReportSource = oReport

  6.     crvMyCRViewer.ViewReport

  7.     crvMyCRViewer.Refresh

  8. Rs.Close

where should I place crvMyCRViewer.Refresh?

thanks