none
Report white space management RRS feed

  • Question

  • Am looking for the ways to avoid awkward amounts of white space.

    Have lots of paragraph sections & labels.  Some of which randomly may or may not have data.

    Ideally when no data - both the label and field would go away - - - - without leaving white space.

    Toggling the visibility in the On Format event of course leaves full white space.

    Can make the text box height absolute minimum, with the can grow; but the label always has data...so it's always full size.

    Have experimented putting in as separate sub reports, a big hassle, so that the label is contained in the sub report - but keeping it minimally small then isn't really working either as one cannot control the Can Grow property on format.

    Any other methods out there?

    Tuesday, May 8, 2018 2:08 PM

Answers

  • Hi,

    Have you tried combining the label and data into one Textbox using Null propagation? This will allow you to control the height of a single control rather than two. For example:

    ="This is my label for " + [FieldName]

    Hope this helps...

    Tuesday, May 8, 2018 7:53 PM

  • too bad development there isn't a 'no space if no data' property option......

    In effect there is.  If you set the CanShrink property of a control to True (Yes), and the CanShrink property of the section in which the control is located also to True, then the control and the vertical space it occupies will shrink to zero height if the control is Null.  There are a number of points to be born in mind, however:

    1.  If there are any other non-shrinking controls alongside the control, including graphical elements such as lines or boxes, then the control will be unable to shrink and you'll still be left with empty space,

    2.  The space of any unused design area between controls vertically will not shrink.  Consequently controls within a section should be vertically contiguous.  This might mean sizing the control to a greater height than that necessary for the font-size used in the control.

    3.  For the same reason there should be no unused design area between the top edge of the topmost control in a section, and similarly, between the bottom edge of the lowest control in a section.

    4.  In the case of a labels report the CanShrink property of the section should be set to false (No).  If the section is allowed to shrink the data will become misaligned with the physical labels on the sheet when printed.  Where controls do shrink in a labels report, e.g where there is a missing line in an address, the following controls will move up, leaving additional empty space at the bottom of the label.

    Ken Sheridan, Stafford, England

    Tuesday, May 8, 2018 9:57 PM

All replies

  • Hi,

    Have you tried combining the label and data into one Textbox using Null propagation? This will allow you to control the height of a single control rather than two. For example:

    ="This is my label for " + [FieldName]

    Hope this helps...

    Tuesday, May 8, 2018 7:53 PM
  • it is looking like that your suggestion is about the best that can be done....

    too bad development there isn't a 'no space if no data' property option......

    Tuesday, May 8, 2018 8:31 PM
  • Hi,

    It's all I can recommend at this time. Good luck with your project.

    • Edited by .theDBguy Tuesday, May 8, 2018 10:22 PM fixed typo
    Tuesday, May 8, 2018 8:34 PM

  • too bad development there isn't a 'no space if no data' property option......

    In effect there is.  If you set the CanShrink property of a control to True (Yes), and the CanShrink property of the section in which the control is located also to True, then the control and the vertical space it occupies will shrink to zero height if the control is Null.  There are a number of points to be born in mind, however:

    1.  If there are any other non-shrinking controls alongside the control, including graphical elements such as lines or boxes, then the control will be unable to shrink and you'll still be left with empty space,

    2.  The space of any unused design area between controls vertically will not shrink.  Consequently controls within a section should be vertically contiguous.  This might mean sizing the control to a greater height than that necessary for the font-size used in the control.

    3.  For the same reason there should be no unused design area between the top edge of the topmost control in a section, and similarly, between the bottom edge of the lowest control in a section.

    4.  In the case of a labels report the CanShrink property of the section should be set to false (No).  If the section is allowed to shrink the data will become misaligned with the physical labels on the sheet when printed.  Where controls do shrink in a labels report, e.g where there is a missing line in an address, the following controls will move up, leaving additional empty space at the bottom of the label.

    Ken Sheridan, Stafford, England

    Tuesday, May 8, 2018 9:57 PM
  • thanks ken - that helped - particularly your hint on #2

    Wednesday, May 9, 2018 1:42 PM