Crystal 9 and Refresh

I have a Crystal 9 report viewer on a form in my VB 6 app. I amend the SQL for my report before opening the form with the viewer on.
When I open the form, the report displays, however I have to click on the Refresh button within the viewer to Refresh the data. I have tried calling the refresh method of the viewer, which doesn't appear to work. How can I refresh the report with the latest data as it is opened?

Uncheck the "Save data with report" option on the file menu or if you are using the CRAXDRT to open/show reports then try the DiscardSaveData method.

Note - I don't have Crystal 9 so the method/menu names may be different.

Cheers, worked a treat!!