VFP9 - speed of display with print preview

[PDCars]

Hi,

I have just converted an existing system from VFP7 to VFP9. To enable the user to view reports prior to printing I use 'REPORT FORM xxxx TO PRINT PREVIEW'. I have noticed that running under VFP9 the report is a lot slower to display than in VFP7. Any suggestions as to what is causing this and how I can speed things up.

Many Thanks,

PD

 

[markros]

Try using the SET REPORTBEHAVIOR 80 for your reports if you're not taking advantage of new reporting features at the moment.

The problem of slow preview was discussed on another forum.

 

[PDCars]

Thanks for this, it sounds like that will work. I did search for this topic but didn't find anything, hence my post!

 

[Mike Lewis]

Another thing worth checking: if you are using a SQL SELECT to prepare a cursor for the report, it could be that's where the slowdown occurs. I'm not saying a SELECT is necessarily slower in 9.0 than it is in 7.0, but there might be factors at work that affect its optimisation. If you are doing a SELECT, it might be worth doing some timing tests to see if that's the culprit.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business