Report formatting issues while trying to print

lbradbury

New Member
Joined
May 14, 2020
Messages
46
Office Version
  1. 365
Platform
  1. Windows
Hello,

I have a report that I'm having a heck of a time trying to get to print properly. The report has a sub form, and is intended to only pull a single header record and any sub records associated. When I go to print this report, the sub form doesn't generate where it is placed in design view but rather it goes to the next page. After the record in the sub-form shows, there is a big white space. I want the report to print with the detail, then the page footer. The page footer is showing on both pages. I've attached photos to help. I've tried modifying the properties but have been unsuccessful.
 

Attachments

  • Design View of Report.JPG
    Design View of Report.JPG
    176.4 KB · Views: 19
  • Page 1 missing subform.JPG
    Page 1 missing subform.JPG
    139.1 KB · Views: 24
  • Page 2 showing sub form records white space and page footer.JPG
    Page 2 showing sub form records white space and page footer.JPG
    63.3 KB · Views: 22

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Maybe make your Page Footer a Report Footer? Based on the content I'm just guessing that's more in line with what layout you're actually trying to achieve...

Otherwise this seems to be working like it's supposed to. Your Detail section is pushed to the next page to make room for the footer since both can't fit in what's left of the page and the page footer - by definition - has to be there.
 
Upvote 0
Solution

Forum statistics

Threads
1,224,824
Messages
6,181,186
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top