Blank page at start of report

T

Tony Williams

I have a report that has 2 sub reports When I view the report the first page
is blank. I've come across subsequent pages being blank when the width is
too long for the page setup but never the first page. Can anyone suggest a
possibility?
Thanks
Tony
 
A

Al Campagna

Tony,
Without being able to see the report itself, I'll assume the problem lies
within the Report Header... since that only fires once per report, and you
only get just one blank page at the start of the report.
In Design mode, place the cursor in your ReportHeader section, and...

Check that you have no PageBreak inserted in that section.
Also check that you have Force New Page = None, and New Row Col = None.

A shot in the dark... but that should be checked first.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
T

Tony Williams

Hi Al checked out the suggestions and no page break and both properties set
to None
I do have page breaks in the report footer where I've placed 2 subreports
that I want on new pages after the main report.
Cheers
Tony
 
T

Tony Williams

Al found the cause but don't know the solution!

If I take one of the subreports away and the page break before it then the
blank page isn't created. So it seems to be having two page breaks and 2
subreports in the report footer that causes the problem? Is there another
way I could get the 2 subreports to print after the main report on separate
pages?

Cheers
Tony
 
A

Al Campagna

Tony,
Hmmm... never ran into that setup before. And, I'm not sure why that
doesn't work, so... trickery will be needed...

1. Any way you can do 1 PageBreak and the first subform, and then enough
empty space to "force" the last Page feed before the 2nd subform?

2. Another trick is to add a calculated field to your main report
query...
GroupNumber : 1
Add a GroupNumber Group Footer to the report, and print the first
subreport in there. The GroupNumber footer/1st subreport will only print
after All the detail is complete.
In other words, the GroupNumber footer acts like a "fake" ReportFooter.
You'll want to do a Page break (or try a ForceNewPage = Before) in that
GroupNumber footer, and you could do the same for your Report footer
subform.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
T

Tony Williams

Hi Al, couldn't get that to work either. Would you mind having a look at the
report layout to see if I'm building it up correctly. Could I email you a
Word
document with an illustration of the design screen. I realise this is not
normally the convention in Newsgroups but it seems the
easiest way to describe what I'm trying to do.
Thanks
Tony
 
T

Tony Williams

Hi Al. Sorry Missed out a step in your second alternative and played around
a little with sizing and it now works.
Thanks for your help.
Cheers
Tony
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

blank pages at beginning and end of access report 2
Last Report Page Blank - 2010 12
Print report and subreport(no data) without blank page 0
extra blank page in report 4
Adding Blank Lines to a Report 0
Report SOMETIMES prints a blank page 2
how to I design an Access report for headed paper on page 1 only? 1
Report to start Print at Bottom of a page instead of top of page 0

Top