Refreshing Crystal Report Using MySQL

[matzos]

I have a Crystal .rpt file that I am displaying through VB using the Crystal .ocx control. The report displays the saved report information fine but when I hit the refresh button I lose the data. The headings and other static objects are still in the report.

When I open the report in the Crystal app, I can refresh with no problem. The data is coming from a single table in a MySQL database.

Here is the calling code I have right now:

Private Sub mnuReports_Click()
CrystalReport1.ReportFileName = App.Path & "\roster.rpt"
CrystalReport1.WindowTitle = "Employee Roster"
CrystalReport1.WindowState = crptMaximized
CrystalReport1.PrintReport
End Sub

Any help would be GREATLY appreciated.