I'm really struggling with some sliding fields and want to run this past you all to make sure I've got it right.
I have three rows of data made up of different fields placed next to each other, left to right, all held in a trailing sub summary part of a report.
There are occasions where two of the rows will have no data, the fields will be empty. In this case, I need the bottom row to slide up to fill the space.
What I've done is to set every field on the two rows to hide if there is no data in them. When all are hidden, the entire row is blank and I'd expect the sliding fields below to move up and fill the space now available by virtue of using the Hide When command.
However, this is not happening (I'm checking in preview mode).
My fields which should be sliding, based on all objects above and with a resized part, are not moving. In addition, they're all top aligned.
Any help on this greatly appreciated thanks