Extra Space Between Detail and Subform(in footer) (1 Viewer)

lwallis

Registered User.
Local time
Today, 05:14
Joined
Feb 11, 2010
Messages
23
The first report example is what I get when I start on the main form and select an organization, run the report, opens report - BIG SPACE between the details and my footer section which holds a subform.

The second report is what I need it to look like, what's strange to me is I get the report correctly when I just run the report (I don't pass the organization into the report from the main form)

Does anyone have an Idea on where to look? I tried changing the background color of the detail section and the footer section to figure out where my problem is but the space just stays white. Any thoughts?

Thanks

Lynda
 

Attachments

  • Incorrect Print.JPG
    Incorrect Print.JPG
    30 KB · Views: 659
  • Correct Print.JPG
    Correct Print.JPG
    37.4 KB · Views: 612
Last edited:

JHB

Have been here a while
Local time
Today, 11:14
Joined
Jun 17, 2012
Messages
7,732
What is the record source for the report, how do you pass the organization into the report from the main form?
Which footer section holds the subform, (page footer, report footer, group?).
Have you tried to make a new report?
Else post a stripped version of your database with some sample data, (zip it) + information how to reproduce the "error".
 

Quaeldorn

New member
Local time
Today, 03:14
Joined
Jan 17, 2014
Messages
8
Bookmarked thread - I have similar issue between Group header and Detail.

In design view, my controls are at the very bottom of the 'InvoiceID Header' section and again at the very top of the 'Detail' section, yet there is still a 1" / 2cm gap between them when in Print Preview view. :banghead:

(Using Office Pro plus 2013)

 

Quaeldorn

New member
Local time
Today, 03:14
Joined
Jan 17, 2014
Messages
8
Dunno if this will solve your problem lwallis, but mine was solved by making the Header section 'Can shrink; Yes'. Perhaps you need to apply this setting to the Detail or Footer sections.
 

lwallis

Registered User.
Local time
Today, 05:14
Joined
Feb 11, 2010
Messages
23
Here is a scaled back version of the db..

thank you for your help!
L:)
 

Attachments

  • ExampleDB.zip
    149.8 KB · Views: 238

JHB

Have been here a while
Local time
Today, 11:14
Joined
Jun 17, 2012
Messages
7,732
Move the subreport from the Page Footer to the Report Footer.
 

Attachments

  • ReportFooter.jpg
    ReportFooter.jpg
    57.2 KB · Views: 571
  • ReportFooter1.jpg
    ReportFooter1.jpg
    72.9 KB · Views: 485

lwallis

Registered User.
Local time
Today, 05:14
Joined
Feb 11, 2010
Messages
23
Thank you!!!! Once again you solved my issue!
 

Users who are viewing this thread

Top Bottom