Prompting For paramters at runtime

[vz]

i am trying to run reports from vb and they run but i can't get it to prompt for data the second time. is there a setting or something that requires the propmt to show everytime the report is ran or is there a way to add the refresh button to the viewer?
Thanks

 

[kmcclung]

To add the refresh button to the viewer, insert the following to your code:

ReportName.WindowShowRefreshBtn = True

 

[Rob2k2]

Think you need to discard the saved data each time you open the report like this:-

cReport.DiscardSavedData

cReport.Database.Tables(1).SetLogOnInfo {your database logon info}

ReportsViewFrm.CRViewer91.ViewReport

ReportsViewFrm.CRViewer91.Zoom (90)

ReportsViewFrm.Show

This is what I use and it works every time