Crystal reports data different from Access Data

I'm trying to generate a report in VB6 by using Crystal connect to an Access Database.

And I use DSN as the connection. My query is so complicate, so i decide to create a temporary table that has the same field as in the crystal. My crystal report connect to that temporary table.

Whenever I want to generate a report, I pick some data from my flex grid and Insert them into the temporary table, then show my report.

the problem is that the data record in the crystal is different from data Access Database. But when I click a refresh button at the top of Crystal page, it become the same as in Access Database.

I don't know if anyone can help me to write a code to make it refresh automatically. I don't want the user to click the refresh
button everytime.


Thanks,

You need to uncheck the checkbox under File > Options... > Reporting tab
"Save data with report" in Crystal Reports.

Otherwise your report has a static snapshot of the data you
were viewing when you designed the report. That is why you
need to click the refresh button.

HTH.

Thank you for your advise. It now works. The Crystal refresh itself and discard the saved data.

But I still have a bit problem that I can't see my last record on the Crystall Report viewer when generating a report.

For example : If I've got 4 records, it shows only 3.
If I've got 20 records, it shows only 19.

I realy don't understand what happen to it.

I hope you expereinced with this problem.

Thanks in advance.

No, I have not come accross that issue before. There could be
some many different things, to pinpoint this one will be hard.
Need more info.