Report's recordset EOF?

  • Thread starter Thread starter TK
  • Start date Start date
T

TK

I am trying to find out how to know when the report's recordset has reached
the end. What I want is, if the data is finished but there is still room on
the page, then I want it to enter some lines (______) until the end of the
page.
I think I have the basics down:
reset counter on each page header format;
count the nuber of lines in the detail print;
*when the recordset eof is reached*
see where the counter is, subtract that from the total number of lines
allowed on the page, and do a loop inserting the lines until the total
allowable for the page is reached.
If I have any of that wrong, please correct me -
Thanks in advance.
TK
 
TK:

This problem is similar to creating a report that has a fixed number of
lines on a page, whether or not there is data to fill those lines (e.g. a
formatted orders report.) If you look on our web, in the free files area,
there's a download called "Other Reports" which contains a report that will
fill a page with a specific number of rows. Take a look at that; it will
likely help you reach your goal here.
 
SA - thanks a million. You were exactly right - a little tweak here, a small
modification there, and I was off and running.
Thanks again!
TK
 
Back
Top