Posted 4 August 2017, 6:00 am EST
Hi there
I have what appears to be a common problem but still can't find a satisfactory answer in the posts I've read. The "last word" on this would be really helpful.
Let's say I have a report that looks like this:
LABEL 1
Text text text etc. etc.
LABEL 2
Text text text etc. etc.
LABEL 3
Text text text etc. etc.
If, for example, the field underneath the LABEL 2 label is empty, I want to remove LABEL 2 from the report and collapse the blank space, thus:
LABEL 1
Text text text etc. etc.
LABEL 3
Text text text etc. etc.
I can collapse the field happily enough using CanShrink, but the label is the problem. If I set it's VISIBLE property to false, it disappears, but the blank space isn't collapsed, so I get this:
LABEL 1
Text text text etc. etc.
[space where LABEL 2 still exists but is not visible]
LABEL 3
Text text text etc. etc.
If I set the HEIGHT property to 0, it still doesn't work.
I know I can solve this by adjusting the TOP value of each control on the page, but this seems a clumsy way to achieve what must be a common requirement.
Send help soon!
Thanks
David