Whit Space in bottom of sub report

[Mina Garas Daniel]

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]

check the subform if Scrollbar is set to Neither.
if not set it.

 

[Mina Garas Daniel]

check the subform if Scrollbar is set to Neither.
if not set it.

Thanks for your help
i set it to neither but nothing change ???

 

[arnelgp]

Set the subfors can shrink to Yes

 

[Mina Garas Daniel]

Set the subfors can shrink to Yes

I did that for all sub reports but it does not working also??!!!

 

[jdraw]

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]

Open the main report in design view. Make sure that there is not excess space between or after the subreports.

 

[isladogs]

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

 

[Mark_]

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.