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.

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.

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:

No prob. Glad to help and hope that VBF will be your new home. :thumb:

Btw, came close? I thought I won. ;)