Extra Page on end of report

[rkrause]

My report has a page header. no report header. At the end of each report im basically getting a blank extra page with the page header on it. Any help?

 

[rainman89]

Does your report run into the margins?? if you open the report in design view, do you see an exclamation point in the upper left hand corner of the report, near the rulers?

 

[rkrause]

my page is in landscape, my margins are all at .25 and my report only spands 9 inches in design view. so i should have plent y of room. and no exclamation point in my design view.

 

[boblarson]

How about posting a screenshot of the report in design view (so we can see the entire thing)?

 

[vbaInet]

It could be that one of your controls is spilling over to the next page. Also check the page setup to ensure the Columns property is 1 and not 2. Add up the heights of your Page Header, Detail and Page Footer and see if the result is over 19cm. If it is then therein lies your problem.

 

[rkrause]

I cant seem to see anything spilling over with any of my controls. ill attach a screenshot.

 

[rkrause]

dont think my attachement worked.

 

[vbaInet]

dont think my attachement worked.

Remove the page break control on the EMPLOYID footer, just below the control that does the count. See if that works.

Also, what is the width of your form? (if the above doesn't work)

 

[rkrause]

when i take the page break out, all my info is on 1 page so im not sure if that fixed it or not. i need a new page for every employee...

 

[boblarson]

when i take the page break out, all my info is on 1 page so im not sure if that fixed it or not. i need a new page for every employee...

I'm pretty sure the page break is the issue. But, if you remove it and then click on the footer and in the properties find the FORCE NEW PAGE and then set it to AFTER SECTION, it might work better (maybe not, but perhaps).

 

[vbaInet]

when i take the page break out, all my info is on 1 page so im not sure if that fixed it or not. i need a new page for every employee...

Click the EMPLOYID header section, go to properties, and under the Format tab you will find a property called "Force New Page". Set it to "Before Section"

 

[rainman89]

on your grouping you can turn on keep together or force new page and it should do what you want without using the page break

 

[vbaInet]

on your grouping you can turn on keep together or force new page and it should do what you want without using the page break

All three messages, 1 minute apart hehe!!

 

[boblarson]

Click the EMPLOYID header section, go to properties, and under the Format tab you will find a property called "Force New Page". Set it to "Before Section"

If you set it to BEFORE section then you won't get the counts on the same page. I believe you would want AFTER section.

 

[rkrause]

Click the EMPLOYID header section, go to properties, and under the Format tab you will find a property called "Force New Page". Set it to "Before Section"

This worked. Thanks.

 

[vbaInet]

This worked. Thanks.

You're welcome.

Also try out a combination of boblarson's and rainman89's suggestions. Test your report thoroughly with at least three pages so you are sure you are getting the desired result.

 

[boblarson]

This worked. Thanks.

Oops, I guess I didn't see that they had said in the group header put before section. I thought they said footer. My bad. I need to get my eyes checked and new glasses I think.