Blank page at start of report

[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

 

[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."

 

[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

 

[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

 

[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."

 

[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

 

[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

 

[Al Campagna]

Tony,
I had better hopes for my second solution, than the first.
You put in some "sweat equity", and fixed the problem.
That's the ticket!
--
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."