>>>Page no. is printed at the bottom of a report. Before generation of
>report,
>>>I wan't to specify 'From Page no.' to ' To Page no' and the Frx must
>print
>>>only the specified page no.
>>>
>>>The problem occurs during Power failure. The Customer has printed say
>some
>>>20 pages and there is a Power failure or Printer problem. Now, he would
>>>like to print the same report starting from 21st page. How can this be
>>>achived ?
>>>
>>>Thankx
>>
>>with some printers, report to printer prompt gives the option of starting
>at a specific page. if your client's printer doesn't, just print the first
>20 pages again.
>
>
>Your answer is not practical. Actually one of the report is 500 pages.
>Say if there is problem after 300 pages, then they cannot start again from
>the begining. Please think and help me out.
>
>Bye
>
>
>
This has been a perrenial problem, not simply with Foxpro, but any report
generated by data.
A lot of this depends on the kind of information in the report, whether its
basically row bound data or more like a document. If its row bound then
there should be some criteria you can use to restart the report at a
reasonable place. After all if the report is based upon volatile data then
the pagination may change from run to run.
So, if you can allow them to print the data based on whatever grouping the
report has they can judge themselves where to report from and to. I accept
that this may make for a bitty report but in terms of page numbering you
could print the page number as _PAGENO+offset, where they can specify the
offset.
On the other hand if the report is 500 pages long you might think about
generating it in a slightly different way. Database/Report engines are not
at their best when handling documents. Word Processors are much better at
handling documents.
So, if your report is more like a document consider exporting the data or
using DDE with Foxpro as the server (my preference) into a Word or similar
word processor. They can then print the report at any page they desire
with as much control over copies as they desire.
Best regards
Simon
==========================================================
Objective Software
http://www.dev-com.com/~objective
(44)(0)1299-823321 Tel Mobile: 44-(0)976-361760
(44)(0)1299-879047 Fax
16 New Street
Stourport on Severn
Worcestershire
England
DY13 8UW
Simon P. Lucy
Support queries
http://www.dev-com.com/~objective/support.html