Crystal Report not showing updated data from SQL server

[[email protected]]

I have to use crystal rerport with VB6.0 to read SQL table, and serve to be chaged dynamically in VB.

I am in a strange situation that my new report file does not show updated data from the server. It displays the data at design time preview.

Private Sub Command1_Click()
CR.ReportFileName = "C:\Progs\NewReport.rpt"
CR.Connect = "DSN = ayaz\ayaz;UID = sa;PWD =;DSQ = LabSoft"
CR.Action = 1
End Sub

This code displays the report, but with static data at the time disign.
if I use Report file as "C:\Progs\OldReport.rpt", it displays updated data.

Please note both are using same SQL Table

Can any one help me?