Let's start with some basics...what database and how are you connecting to it?
>Hi everyone. I just finished developing a report that processes somewhere in the vicinity of 6000 records or so. Within the Crystal Reports 9 Application it takes roughly 45-60 seconds. However, when I use the RDC ActiveX control within FoxPro, it cranks the CPU to 99% for 11 minutes. Now, I am guessing that the RDC just doesn't have the power behind it like the full blown application, which I can understand. My workaround was to display a WAIT WINDOW using a timer that refreshes every second, adding a "." to the end of the message so at least the user knows that the program is thinking, and not frozen. The problem is that when I execute the RDC's ReadRecords() method, which throws the CPU into 99% usage, it prevents my timer from firing which means the message never displays to the user.
>
>Is there any way that I can force my timer to run in the background while Crystal is reading the database records? I looked for an event within the RDC's ActiveX Control with no success.
>
>I look forward to any input. Thanks in advanced for your time.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer