Report Designer - how to hide a field and not have the space for that field still show on the report

I see you have the Layout field set to “Can Grow”. Can you make the size of the box smaller in the report designer, so that if there’s no text it takes up very little space but if there is more text it grows to fit?

I’m not sure if that would work or not but it might be worth a try.

 

Another option is to add multiple detail sections to your group footer. This way you can set the visibility for the detail section containing the custom verbiage.

To add detail sections, open the report file in notepad, or similar program that lays out code in an easier to read format than notepad. Then add as many detail sections in the group footer as you need. Then save and open again in Report Designer. 

@donnadeskins55 For this issue it seems like somehow the expression is neither NULL or empty, maybe you want to check the Len() of the field and see if it returns a specific value for this and then specify that value in the visibility expression?

Seems like something must be populating in there

@BenjaminCrisman, I’m not sure I understand what you mean by checking the length and including that in the visible expression.

What would that look like?

Thanks!