Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

report shows up with blank sections....need help to know why

Status
Not open for further replies.

julius1

Technical User
Oct 31, 2002
142
US
I have a problem with a report that I populate with data from a form with a few sub forms in it. The main report is designed off the main form and I have added sub reports from the sub forms. My problem is that when I go to pull the data together on the main report some of the sub reports appear as blank pages. When I go to the actual sub form reports themselves they are popluated. What would cause only some of the data to populate and not all of it? This does not occur all of the time either. The Sub reports always populate, only when they are brought together to make the final report does the blank pages appear. Can anyone help me get rid of the ghost pages???
 
First make sure that your subreports arent placed inside of the main report outside of the page margins, this will create blank pages within the report.

Next, I make my subreports as small as possible within the main report, like I can only see the scroll bar showing in design view of the main report of each sub report. Then I set each subreport to can grow and can shrink so if there isnt data in that area, I dont get big blanks.
 
I'll give that a shot and see what I wind up with, thanks!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top