Deleting blank Pages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have alot of Blank pages when i print out my Reaports, is there a way I
can delete them or aviod having them in my Report?

Thanks,
Tatum
 
I dont know.. I tried changing the width of the information on the pages but
i still get a blank page. it is absolutely blank there is nothing on it
except the Head and footer.

What can i do to remove it?
 
You can't remove something if you don't know what is causing it. Do you have
any section properties set to force new page? How wide is your report? What
are the top, bottom, left, and right margins? Is the report landscape or
portrait? Are there any page break controls on the page? Are you running any
code (or macros) in the report?

What have you done to troubleshoot?

If you can't fix this, just create a new report and delete the old one.
 
THere is no section properties (force new page). M report is 6 1/2. the
margin are:Top- 1, Bottom- 1, Left- 0.5 & right- 0.5 .
The report is Portrait. I am not running any Macros.
 
How high are the sections? Do you have any blank records in your report's
record source?
 
You know, one thing you may want to check is to see if the design view of the
report shows any extra space after all your data that you may be able to
remove. If there is extra space (you said the blank pages do have the header
stuff), remove any excess header junk (for example, if you have a big blue
line that goes through the whole header, resize the big blue line so it ends
closer to where your data ends).

After you have nothing but white space in this excess room, put your cursor
over the line on the far end of the report in design view so you get the
cursor that has two horizontal arrows. Click and drag so the end of the
report ends where the actual visible stuff in the report ends.

You should also check to make sure that each section of the report (report
header, Detail, etc.) does not have more white space at the top or bottom. If
any do, this can be changed similar to how I described above. Just be sure
not to take TOO much away. You want your report to look nice.

I hope this helps you. I've run into the same problem many times, where the
report prints blank pages for seemingly no reason. For me, it has always
ended up being because the white space of the report accidentally got
extended beyond what one page could handle.

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy

~~~~~~
| |
|c--OD
| _)
| |
|-. |
/ `-# /A
/ /_|..`#.J/
||LJ `m''
ptaylor
 
What height is 7? What is the height of your:
Page Header:
Page Footer:
Detail Section:
Other sections:

If your detail section height is 7, you must realize that you will only
print one record per page.
 
hey Tasha,
Before u sart all over again, publish your report with MS-Word.
If a blank appears that means you have to shrink your controls, report height
and width.
I think this will solve your problem
There is not extra space its only what has to be there... i am running out of
ideas!
You know, one thing you may want to check is to see if the design view of the
report shows any extra space after all your data that you may be able to
Click to expand...
[quoted text clipped - 50 lines]
Click to expand...
 
Back
Top