Need some help

[vsap]

Hi guys,
I have this report which generates more than 1000 pages and it take so much time , and user are getting on me, is there any way that I can generate 0ne page at a time or 10 pages at a time.
Any suggestions are welcome, and thanks in advance.

-vsap

 

[ColinEssex]

use a more limiting criteria in the query

Col

 

[Dennisk]

Well you could put the data in to a temp table with an autonumber and use the number to determine where to print from but you would have to do this in code to maintain a count of the number of pages (or rows).

 

[ColinEssex]

and thanks vsap for posting such a descriptive title to your thread - that will help everyone who is searching for an answer to a similar problem

Col