Last Record Is Missing in CR

[lambra1]

Hello everyone.

I am using vb6 and cr8.
When I run the report from the vb enviroment (using crystal report control) I am missing the last record.
If I run the report from the cr designer everything is fine.
The datafile (table) that I am retrieving data from is in access.
Has anybody an idea why is that???


Thank you,
Alex

[Hack]

Welcome to the forums.

How are you running it from VB? What code are you using?

[lambra1]

Dear Hack thank you for you reply.
The same happens if I run .exe or from the design enviroment.

I load a temp table with some results which CR is linked to

and then the code is like this

CrystalReport1.DataFiles(0) = db1
CrystalReport1.ReportFileName = PrnPath & "123.rpt"
CrystalReport1.DiscardSavedData = True
CrystalReport1.Action = 1

Thank you

[lambra1]

Another thing that I just saw is that from vb runtime if I "Refresh report data" (destination Window, Preview Window -->Refresh) then the missing record appears.

Is this strange or what?