VERY WIERD-DROPS LAST RECORD OR TWO??

[dabineri]

I am using CR9 RDC with VB6 in Win XP using an Access data base (DAO) and have not been able to get an answer to the following issue for the past year! I hope someone can help.

When previewing a report (I would call it very simple, one group) it omits the last record (and sometimes two) of data until the Refresh Icon is clicked a couple of times. Here is the code I am using:

Dim crxApplication As New craxdrt.Application
DIM Reportt As New craxdrt.Report
Dim DB As craxdrt.DatabaseTable

crxApplication.SetLicenseKeycode ("A6...... ")

Set Reportt = crxApplication.OpenReport(Report.rpt)

Reportt.DiscardSavedData
Set DB = Reportt.Database.Tables(1)

DB.Location = path+"/file.mdb"
CRViewer9.ReportSource = Reportt
CRViewer9.EnableRefreshButton = True
CRViewer9.ViewReport
CRViewer9.Zoom (75)
Reportt.SelectPrinter DriverName, DeviceName, PrinterPort
Reportt.PaperOrientation = crPortrait
Reportt.ReadRecords
CRViewer9.Refresh

Please let me know if you have any idea at all as to why records do not show when the report is previewed. The data is in the database table but is not showing up on the screen. Please let me know if you have any ideas at all as I have tried everything that I can think of.

Thanks, David Abineri

 

[abaldwin]

Man would I like an answer to this one as well. My problem is similar but only occurs when I use the problem report as a sub report. When I call it by itself the report runs fine.



Andy Baldwin