Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Terry Parkinson
  Where is Terry Parkinson?
 Litchfield
 New Hampshire - United States
 Terry Parkinson
 To: Cathy Pountney
  Where is Cathy Pountney?
 Jenison
 Michigan - United States
 Cathy Pountney
 Tags
Subject: RE: Fill rest of report with lines
Thread ID: 189175 Message ID: 189206 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Reports and Printers
Date: Wednesday, August 13, 2008 8:25:57 PM         
   


> > Is there an "simple" way to fill out a report with blank lines? I have a production schedule that may fill all, half, a third of a page, and they would like ruled lines for the rest of the page. This covers a number of production lines for each weekday--one production line per day per page, so it's not just a matter of adding blank records to the report cursor for the one page--although if there's not a more elegant answer I may look at that approach.
> > Thanks!
> > Terry
>
> One trick is to use a report variable to count the detail records printing on the page. In a data group footer, add a field with something like this:
>
> REPLICATE(REPLICATE("_", 50)+CHR(13), 99-rnLines)
>
> where 99 is the total lines that would fit on a page and rnLines is the report variable that counted the number that did print. Be sure to mark the field as stetch with overflow.
>
> Cathy Pountney
> www.cathypountney.blogspot.com

Thanks Cathy. I'll have to try that. One complication is that the detail band is somewhat oversized. While it's only one line, it includes space above and below and the drawn line to give room for written notes--I'm not sure I could get that spacing in the footer. Perhaps with 2 CHR(13). Anyway, adding the records guarantees the same spacing, so all set!

Terry

ENTIRE THREAD

Fill rest of report with lines Posted by Terry Parkinson @ 8/13/2008 4:28:53 PM
RE: Fill rest of report with lines Posted by Cetin Basoz @ 8/13/2008 4:43:51 PM
RE: Fill rest of report with lines Posted by Terry Parkinson @ 8/13/2008 4:50:30 PM
RE: Fill rest of report with lines Posted by Anders Altberg @ 8/13/2008 6:48:12 PM
RE: Fill rest of report with lines Posted by Terry Parkinson @ 8/13/2008 7:55:58 PM
RE: Fill rest of report with lines Posted by Cathy Pountney @ 8/13/2008 8:00:41 PM
RE: Fill rest of report with lines Posted by Terry Parkinson @ 8/13/2008 8:25:57 PM