loading data to a crystal report one by one

[niroshan2006]

I have used crystal report 9 in my vb6 project with sql server 2000. I have used a combo box on a vb form to place file numbers and ask user to select a number to generate a report. at the first time report is visible. for the second time no report is generated. but report format is visible. I have used refresh method to the crystal report viewer ( CRViewer91.Refresh). please help me soon.
tks
Niroshan

[Coke]

hey niroshan2006, i tried using the refresh(coding) but i didnt work too. It just show the previous report right.? Mine did.
Did you try the manual refresh button.?
hmm. you are only using one report to display for each file number? Or?
And does that report recieve parameters.?

[RobDog888]

Did you change your RecordSource for the viewer each time too?

[niroshan2006]

hey niroshan2006, i tried using the refresh(coding) but i didnt work too. It just show the previous report right.? Mine did.
Did you try the manual refresh button.?
hmm. you are only using one report to display for each file number? Or?
And does that report recieve parameters.?

Yes I used manual refresh also. when I used refresh method and manual refresh I get only the blank report for the second file number. I used only one report to display details of all files

[niroshan2006]

Yes I used manual refresh also. when I used refresh method and manual refresh I get only the blank report for the second file number. I used only one report to display details of all files
(Rate)

[Coke]

hmm. have you tried what ROBDOG888 suggested.? the source.?

[niroshan2006]

hmm. have you tried what ROBDOG888 suggested.? the source.?

no
PLEASE HELP ME BY GIVING THE CODE

[RobDog888]

If you have one report already loading then there is no real code to post as you would just change your report that you are passing when you .OpenReport and then .SetDataSource to the ADO recordset that pertains to the report and finally set the .ReportSource to the opened report object.