No data refresh

[kimtp]

Using CR with Vb6. Designed the report in CR and then did a Project, Add CR, From existing report. My problem is when I add data the report does not pick up the change. The changes have been made to the DB and when I exit the program and restart, the data shows up in the report.

Here is the code so far:

frmPayments.Refresh
With crvPayments 'CRViewer
.ReportSource = crPayments
.Refresh
.ViewReport
End With

I call the report with frmPayments.show

Any help is appreciated

Thanks

Kim

 

[dgillz]

I am niot much of a VB programmer but I believe there is a property called "discard saved data" which must be set to true so that the report will refresh.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[synapsevampire]

Here's a couple of references that should get you out of it:

http://www.tek-tips.com/faqs.cfm?spid=766&sfid=1006

The function dgillz refers to is:

Rpt.DiscardSavedData

-k

 

[carlosjrr]

You must be sure that the option "Save the data with reports" under File menu in Crystal Reports is not selected.