The data is sorted by date. However, within a particular date, the report is upto 5 pages say starting from 75th page to 80th page. Now say there is a problem on 77th page. Moreover, the s/w should be such that if such a problem occurs and my customer calls up and reports the problem; then I should reply that JUST GIVE FROM AND TO PAGE NO.s AND THE S/W WILL PRINT PROPERTLY. I still feel there might be a solution to this in Report Writer. Many people have migrated to VFP 5.0. How do I reach more Guru's of Foxpro ?

>>>>>>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
>>
>>Before Report writer was introduced one could use _pbpage to suppress the
>>unwanted pages. But, once Report Writer is used we have no control over
>>Starting page no. It think, there is some solution. Meanwhile my report
>>is a type of document where there is no grouping or control over the rows.
>>
>>
>>
>So none of the data is sorted in any way?
>
>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