Whit Space in bottom of sub report (1 Viewer)

Mina Garas Daniel

Registered User.
Local time
Today, 09:07
Joined
Jul 21, 2017
Messages
66
Hello everybody

I face a common problem for most of you but its first time for me

I make a sub report but i have a problem there is a white space in the bottom of it
when i make another sub report i got white space again
when i search on this forum i found some solutions like make can shrink and can grow = yes but it does not working with me

so how i can remove this white space

any suggestions
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 15:07
Joined
May 7, 2009
Messages
19,169
check the subform if Scrollbar is set to Neither.
if not set it.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 15:07
Joined
May 7, 2009
Messages
19,169
Set the subfors can shrink to Yes
 

jdraw

Super Moderator
Staff member
Local time
Today, 03:07
Joined
Jan 23, 2006
Messages
15,364
Check the links at the bottom of this thread for similar threads. Check a few, you may just find an answer.

Good luck.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 03:07
Joined
Feb 19, 2002
Messages
42,981
Open the main report in design view. Make sure that there is not excess space between or after the subreports.
 

isladogs

MVP / VIP
Local time
Today, 07:07
Joined
Jan 14, 2017
Messages
18,186
I think you need a combination of ideas already suggested and a couple more.
There is no one solution that will fit all cases as each report/subreport combination is different

I'll explain this using screenshots of a report with 10 subreports:



In design view notice that I've shrunk each subreport to a small size.



Set the detail section of the main report to Can Grow = Yes, AutoHeight=No
You may also wish to experiment with other settings : KeepTogether= Yes/No and ForceNewPage



I've also added a page break control (highlighted in image 2) with the best position found by trial & error

Finally experiment with the property settings for each subreport:
This time i've used CanGrow=No but whatever works for you

 

Attachments

  • Report.PNG
    Report.PNG
    87.5 KB · Views: 706
  • ReportDesign.PNG
    ReportDesign.PNG
    48 KB · Views: 713
  • MainReportDetailProperties.PNG
    MainReportDetailProperties.PNG
    9.3 KB · Views: 682
  • SubReportDetailProperties.PNG
    SubReportDetailProperties.PNG
    9.3 KB · Views: 659

Mark_

Longboard on the internet
Local time
Today, 00:07
Joined
Sep 12, 2017
Messages
2,111
Also double check the spacing in the sub-report. If you have excess space at the bottom of the report that will appear in the main report.
 

Users who are viewing this thread

Top Bottom