missing last record in report

I use a msaccess97 temp table for my report.
It is a very simple report.
The crystal report 8 is connected to this temp table and display the information direct from this table.
The information in the temp table is all correct but when I use the vb6 aplicattion to call out this report the last record is missing.
anpecoAsked:
Who is Participating?
 
frodomanConnect With a Mentor Commented:
Is it possible that the last record hasn't been commited yet or is still in a "locked" state when the report is executed?
0
 
frodomanCommented:
Are you sure that the last record isn't just being displayed on another page?  There could be a slight difference in the spacing / fonts so a report that previews in one page in the developer may spill over to a 2nd page when using the activex viewer.

0
 
mlmccCommented:
listening
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
anpecoAuthor Commented:
this isn't the problem. i've tried diferent number of records. For example temp tables with 1 record will show empty reports.

If i re-order records from table to report last record table is missing in report, not last record in re-ordered report.
0
 
anpecoAuthor Commented:
That's ok.  EUREKA !!!!!
Adding "CommitTrans" instruction before report call works fine.

Now all records are displayed.

THANK'S
BEST REGARDS.
0
 
frodomanCommented:
That's what I meant by the last record hasn't been committed.  So it's working now, right?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.