loading data to a crystal report one by one
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
Re: loading data to a crystal report one by one
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.?
Re: loading data to a crystal report one by one
Did you change your RecordSource for the viewer each time too?
Re: loading data to a crystal report one by one
Quote:
Originally Posted by 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.?
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
Re: loading data to a crystal report one by one
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)
Re: loading data to a crystal report one by one
hmm. have you tried what ROBDOG888 suggested.? the source.?
Re: loading data to a crystal report one by one
Quote:
Originally Posted by Coke
hmm. have you tried what ROBDOG888 suggested.? the source.?
no
PLEASE HELP ME BY GIVING THE CODE
Re: loading data to a crystal report one by one
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.