report printing extra pages - sometimes....

[calian]

I have written a report that summarizes a group's activity over a period of time specified at run-time. The records from which it draws the data have 60 categories of activity (fields) in each record. Each record is a day's activity, each category may contain a value from 0 to any-number, usually less than 10. The report consists of textboxes each of which displays the Sum() of a particular category of activity. If the sum for a category is zero, the box and it's label are not printed.<br><br>So far, so okey-dokey. The report runs fine, the calculations are correct, the customer even likes the layout of the thing - *EXCEPT* for one problem.<br><br>If the report will fit on a single page, well and good - out it comes with proper headings, totals, etc. Looks fine. But, if it runs to 2 pages, which it will when there are values in all the categories, the report first prints a page with only the heading (company name, report title, and date range) - and no data! Page 2 and 3 have the actual output of the report. The headings appear properly on those pages, too, and the layout is correct; the report just starts on page 2 instead of 1.<br><br>It's not a printer problem - the report displays with a &quot;header-only&quot; page in preview mode.<br><br>I could, I supposed, do a quick-and-dirty fix and make the typeface so small that the report *always* fits on one page, but that's pretty thin, and doesn't tell me how to fix it the next time.<br><br>Can some one tell me what obvious thing I'm overlooking? Thanx.<br>

 

[DougP]

Not sure what to tell you without seeing the report.<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[xtreme1]

Does it print a blank page between pages two and three ever? <p>xtreme1<br><a href=mailto:rbio@excite.com>rbio@excite.com</a><br><a href= > </a><br>

 

[famousb]

this may not be it, but check to see for each section of the report that &quot;Force New Page&quot; and &quot;New Row or Column&quot; are both set to &quot;None&quot; and that &quot;Keep Together&quot; is set to &quot;Yes&quot;.<br><br>also, is the size of your header section small enough to allow the rest of the data to fit on the page?<br><br>without seeing the report it is hard to say what's wrong. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>