>>I have an application that uses the standard report verb:
>>
>>report form myreport to print
>>
>>I'm using VFP 5.0, version date August 21, 1996 on Windows 95, NT 4 LAN.
>>
>>The problem is that the report will print in excess of 20,000 pages, at one page per record. It is scheduled to print
>>overnight, and stopped on page 9999. This seems like a coincidence to me, and it's the first time I've ever run
>>this application. Does anyone have any experience or knowledge about a page limit of 9,999 pages?
>>
>>Thanks.
>
>If you call MS and ask enough questions they will admit that this is a problem, for some reason they won't say error. Even though you can include begin and end page numbers. Either in the REPORT FORM command line or in the prompt dialog. Neither one works. 9999 is largest page number that a report in fox can have. FWIW the limit in Word, Excel, etc... is 32768, and this is what it is supposed to be in VFP. Now for the solution to the problem.
>
>The only way around this limitation is to determine the last record printed. Then you will want to copy the rest of the file to another table. Deleting the records wont work as the way fox does its reports it will still see them. Not sure why but with my experience on this that is the only conclusion that I could come to. Once you have this new table you can modify the frx field for the page number to be _pageno + 9999. This will make the page numbers come out correctly on the rest of the report. At least pages 10000 to 19998 (it might be 19999). With more pages you get the idea of what is going on.
>
>As mentioned before I have sent this to MS 2 times now. With exact steps to reproduce the problem and the workaround. Yet they don't seem to want to admit to this one being a problem.
>
>HTH,
>
>REM
I'm not trying to defend Microsoft in this. I'm not sure they need defending. There would inevitably be some page limit to reports, in this case it's 9,999. Even if it was the 32,768 that you suggest Word and Excel allow, there would be some instances where that was not a high enough number and a work around would be required. You have a good work around and I compliment you on it. The fact that there is an actual limit below infinity is not, IMHO, an error. It's just a fact. If the limit was 100 pages or even 999 pages I would agree on it's practical limitation for most users but let's be serious. Most of us will never generate a printed report of 10,000 pages or above so the limitation seems pretty reasonable.
Thanks for listening.