I am currently printing a report th

[narry]

I am currently printing a report that exceeds 9999 pages. I am able to VIEW all 10020 pages of my report, but only the first 9999 pages ever get printed.

I tried using the 'to printer prompt' to print my report in batches not exceeding 9999 (ie print from page 1 to 9000, then from page 9001 to 10020), but I still keep getting the error msg - "This value is not within the page range. Enter a number between 1 and 9999".

It seems that vfp 6 has a limit to pages that can be printed in a report (Not exceeding 9999).

My report cannot be truncated or reduced in any way. I must print all 10020 pages.

Can anyone help????

 

[ramani]

HI
I am not awre of anything limiting to 9999 pages in VFP.
_pageno is the the system counter for pageno. _PBPAGE and _PEPAGE is the page range used for backward compatibilty.
_PEPAGE is generaly will have a value 32767. So if all pages are selected for a report, the range upto 32767 shall not pose any problem.

However, you can try to force in the value of _pePage to 32767 and try printing. Also check if the Operating system is having any such limits set (especialy, if you are using a network printer).
To force the value into _pePage system variable, open the Data environment of report designer and in its init event put the code..
_pePage = 32767

Hope this helps ramani :-9
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[rgbean]

Actually the 9,999 page limit is documented in the help file. This was changed in to 65,534 in VFP 7.0.

Rick

 

[narry]

Thanks Ramani,

I tried to force in the value of _pePage to 32767 in the init event/of the data environment/of the report to be printed as you suggested, but I still got the page error when printing beyond 9999.

One of two things happen -

1. If you set the print job to print ALL pages, The page counter on the print window goes from 1 to 9999 and then stops. Viewing the print on the print queue reveals that 9999 pages are actually printed.

2. If you set the print job to print from 1 to 10020 pages, then you get this error msg from the print window - "This value is not within the page range. Enter a number between 1 and 9999."
You get the same msg even if you break up the print job into 2 parts - the first part 1-9999 prints fine but the second part 10000 - 10020 gives the above error.

Either way, STRAGELY enough, you are allowed to VIEW all 1-10020 pages in the page preview (i.e. if you put code to preview).

What I did to temporarily tackle the problem is send my records to be printed to a cursor, count the cursor records and note begining & end (1 to 10020 records), and then print the report in batches (1-9999 & then 10000-rest).

I didn't spend anytime looking at OS settings for printer or even network settings. Our print server is an AS400 and our network printer for this application is an IBM 6262 T14. I don't know if there are restrictions to print size on these equipment.


Thanks Anyway though....
It's good to know that there is help out there.....