Half of report empty

David Lelièvre
David Lelièvre used Ask the Experts™
on
When I generate a report, half of it has a lot of empty space even if I've set the property of the report "To shrink" to yes.
Why is this happening?
Report-layout-issue.png
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017
Commented:
The shrink/grow setting does not shrink/grow horizontally.  It only works vertically.  You need to adjust the width settings yourself so that the report is centered on the page if you want it to be more aesthetically pleasing.
Nerd
Most Valuable Expert 2012
Top Expert 2013
Commented:
You'd have to adjust the width of the line to span only the expected width of your data.  Since the alternating colors are actually the background for the report's detail section, rather than actual controls, you would have to set the page margins (through Print Preview) to make the 'striped' area narrower, while keeping it centered.

Author

Commented:
Alright! Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial