Hi Naomi,


I wanna share with you the solution suggested by Christof Wollenhaupt.

He gave me an idea about the report not being able to find the table. Here's probably what had happened: The scratch tables that my report was using were just in a local directory; but since all my work paths were pointing at our server, the report tables were at first visible; but after going to the next page it was missed by the report object. This probably explains why I can sometimes advance to the next page, most of the times not. When I defaulted to the local directory where the report tables were, the report worked perfectly. I just reverted back to the original default after the report.

You might want to consider this solution the next time you encounter a similar problem. Yup, its me, im the culprit, guilty as charged. :)

Thanks again for sharing your insight on this matter.