Changing Data Source not changing data in report 1

[yme]

I'm having a problem with changing the data source and the report not showing the change. I'm using VB6 and CR8. I'm using the .SetDataSource and I'm giving it an ADO recordset. I have a screen that takes a couple of variables that I use to make a recordset. When I run the report the first time, the report works fine. I close the report (but not the program) and when I run the report again, the recordset in the program changes, but it doesn't change in the report. I keep getting the old data. It doesn't seem to take my new recordset. How can I fix this.

Thanks for your help.

 

[peterdozzi]

yme,

Have you tried "Verify Database" (or something similar found under Database on menu) when you open the report the second time? Although I've not worked with VB and Crystal, I do know that if a change is made to the datasource, you have to verify the report against the datasource. If it gives you a message *something like* "the datasource has changed, prepare to fix report?" then you know the change is interfering with the connectivity to the report. Try this to see if you can narrow down your problem.

I hope this helps....
Ruth

 

[StevenK]

It may be wise to ensure that the Cystal Report is saved without data (uncheck the 'Save with Data' from File menu) and use a call similar to 'CRReport.DiscardSavedData' (this is what I use through Delphi 5).
Hope this proves useful ...
Steve

 

[yme]

The Report.DiscardSavedData is the ticket. Thanks a lot for your help.

 

[maidenfan]

I'm working with the same softwares and the same troubles:
VB6+CR8+Access2000

The error message is: 'Phisycal database not found'

Someone has a solution to this?

 

[StevenK]

It's either that you don't have the CRViewer.dll copied and registered (if you make use of the 'CRViewer' component).
Alternatively it may be that the database access DLL's required are missing. I make use of DLL's like 'p2sodbc.dll', 'p2ssql.dll' for accessing SQL Server database. These need to be on the client machines. If they're not then you might get this 'physical database not found.'.
Steve