help on refresh crystal reports 4.6, error

i am having problems tryin to get the reports to show new data .... if i gointo cr and force it mamnually it will show only that once and i would have to do that every time... i have unchecked the save data with report and when i do that i get an error...:
error 20536: runtime error unable to connect in correct log on parameters

if i have that checked it works fine....
i dont know if there is other things to do to show the new data i cant find a .refresh or anything like that in the crystalrerport ocx thing....
how can i get this to work.. please help......



CrystalReport1.ReportFileName = "\\Server\reports.rpt"
CrystalReport1.GroupSelectionFormula = "{Mytable.Status} = " & "'Current'"
CrystalReport1.Action = 1

The error message is giving you the answer. It would appear that the database your report is trying to connect to requires authentication. It works when 'Save data with report' is checked because it doesn't actually have to access the database to display your report.