Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Long delay before producing report
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01204027
Message ID:
01205214
Views:
18
>Bonjour Naomi,
>
>Thank you for your help. I tried the "classic" solution ( SET REPORTBEHAVIOR 80 ) but it doesn't work. I looked further and I noticed a very high network activity while the preparation of my report. My report was built around different files linked together with some "set relation to..." So I changed my approach and generated a single SQL cursor and I modified my report to reflect that change. This was the solution.
>
>I'm surprised how the "set relation to..." made a so big difference from one version to the other.
>
>Thanks again,
>
>Normand

Glad to hear that the problem is solved. I prefer to always build a single cursor, so I haven't really encountered a problem. Here right now we're using VFP8, going to switch to VFP9 soon. I noticed that several reports in the already built applications use relations. It may become a problem for us too when we'll switch, so at least I know about resolution for the problem.

Thanks again.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform