Not so crystal clear after all (crystl32.ocx)

[Joffies]

I use crystal 8 developer to design my reports and use the crystl32.ocx to view the reports in a vb application. My problem is the following. Sometimes when i view the report it shows all the data and then sometimes it dont. If i step through the code line by line unitl it shows the report then there is no problem. It's as if the computer is too fast sometimes. What i did then was to put in a timer to delay the view of the report and then it shows all the information.

What could be the cause of this??????? Please help!!!!!!! I am going $%^@%^$#$%^#$%^ at the moment!!!!

Thanks in advance!!

[Abu haider]

I have noticed if client server cursor is used with Jet (Access) Database, writes to the database are not immediately reflected in the other connections. This is probably because the driver launches a different thread to update the database and returns to the main program. But I am not certain.
A few seconds of delay usually ensures proper read back from the database.

If this is what causing your problem, try using server side cursor, or use sql to update your tables.

[Joffies]

I have solved the problem!!! All you have to do is before you call the report just set the following!

Crystalreport1.reset



That is all!!!!!