A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Blank Pages at the beginning of Parent Report with 5 child or sub reports



 
 
Thread Tools Display Modes
  #1  
Old March 4th, 2005, 08:20 PM
Cyndy Sheehan
external usenet poster
 
Posts: n/a
Default Blank Pages at the beginning of Parent Report with 5 child or sub reports

I have been searching for a way to fix this problem and to this point have
found nothing that will fix it. I have two Reports that contain 5 child or
sub reports. The two reports in question were designed in an Access 97
version database and have been in use for the last few years. The reports
have always had the bug of the first page of either report is blank with
just the page footer showing up and all other pages print fine and no
missing data. We have upgraded the database to 2002 and open it also in
2003 but not converted to 2003. One of the reports is now 444 pages and it
has199 blank pages with page 200 - 444 showing the correct data. The other
report now has 336 pages and it has 18 blank pages with page 19 - 336
showing the correct data. No other problems. We have not modified the
report or the subreports. Nor have the queries suppling the data been
changed. I have tried all the suggestions I found in my search - Can Grow
and Can Shrink set to yes on the child reports, the object widths of the
child reports are enough to allow for the information to print within the
margins. I have tried rebuilding it, and still get the same outcome. I can
not figure out what has happened or changed from the upgrade. I am not sure
what is causing the blank pages in the front of the report. I can find no
page breaks and the detail section of the Main report has the Force New Page
option set to "after section". Any suggestions or directions would be most
appreciated. Thanks


  #2  
Old March 4th, 2005, 10:36 PM
Cyndy Sheehan
external usenet poster
 
Posts: n/a
Default

Please disregard this post - I found that the error lied within the filters
for the reports. I am sorry to post a a cry for help that was a false
alarm.

Thank you.
"Cyndy Sheehan" wrote in message
...
I have been searching for a way to fix this problem and to this point have
found nothing that will fix it. I have two Reports that contain 5 child or
sub reports. The two reports in question were designed in an Access 97
version database and have been in use for the last few years. The reports
have always had the bug of the first page of either report is blank with
just the page footer showing up and all other pages print fine and no
missing data. We have upgraded the database to 2002 and open it also in
2003 but not converted to 2003. One of the reports is now 444 pages and it
has199 blank pages with page 200 - 444 showing the correct data. The other
report now has 336 pages and it has 18 blank pages with page 19 - 336
showing the correct data. No other problems. We have not modified the
report or the subreports. Nor have the queries suppling the data been
changed. I have tried all the suggestions I found in my search - Can Grow
and Can Shrink set to yes on the child reports, the object widths of the
child reports are enough to allow for the information to print within the
margins. I have tried rebuilding it, and still get the same outcome. I
can not figure out what has happened or changed from the upgrade. I am not
sure what is causing the blank pages in the front of the report. I can
find no page breaks and the detail section of the Main report has the Force
New Page option set to "after section". Any suggestions or directions
would be most appreciated. Thanks



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Blank Pages in Access report Jan Buckley Setting Up & Running Reports 1 February 10th, 2005 05:47 PM
Blank Pages in Access report Jan Buckley Setting Up & Running Reports 0 February 7th, 2005 05:09 PM
report sometimes prints final blank page (except for page header) John S. Ford, MD General Discussion 1 December 11th, 2004 10:28 AM
Blank Row in Report Matt General Discussion 5 September 29th, 2004 05:05 PM
Help! I have 14 pages in a worksheet, pages 8-14 are blank and print that way. How can I delete only the blank pages? I tried delete worksheet and it deleted the whole thing. Peggy New Users 2 April 28th, 2004 09:20 PM


All times are GMT +1. The time now is 06:55 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.