If they have a problem on the 77th page then they re-run the report from the date that failed and give the beginning page number of that date. Simon > >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 > > > ========================================================== 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