Problem using SetDataSource * resolved *
Hi all,
I'm having a problem using Crystal 8.0 and Visual Basic 6.0. I'm selecting my data into a recordset but the Crystal report continues to use the data from the database I used to design it before I imported it into the project. I can't seem to make it stop going to the database.
I populate a recordset called rsTempRecordSet.
Then I use:
If (CR_CustomReport.HasSavedData) Then
CR_CustomReport.DiscardSavedData
End If
Then I use:
CR_CustomReport.Database.SetDataSource rsTempRecordSet
It still uses the database though. Any suggestions.
Re: Problem using SetDataSource
This is usually from having the option in CR to "Save data with report". Uncheck
it and re-save your report. There is also a .DiscardSavedData method of the
report object that you can invoke too.
Re: Problem using SetDataSource
Quote:
Originally Posted by RobDog888
This is usually from having the option in CR to "Save data with report". Uncheck
it and re-save your report. There is also a .DiscardSavedData method of the
report object that you can invoke too.
Yaba-daba-doo :p
It was the "Save data with report" option. I was beating my brains out on that and ended up working around it with a hammer.
By the way I hit a couple of forums on this and you are the only one that came close.
Thanks! :wave:
Re: Problem using SetDataSource * resolved *
No prob. Glad to help and hope that VBF will be your new home. :thumb:
Btw, came close? I thought I won. ;)