In my report footer, I need to hide fields that are null but keep the remaining fields together. Each fields control source is a formula / expression builder output.
Report Footer:
Field1
Field2
Field3
Field4
Desired output
Field1
Field4
In this example, Field2 and Field3 are the only null fields.
I've tried setting the field height to 0, stack all of the controls on each other, then set Can Grow to yes. The fields displayed over each other.
Report Footer:
Field1
Field2
Field3
Field4
Desired output
Field1
Field4
In this example, Field2 and Field3 are the only null fields.
I've tried setting the field height to 0, stack all of the controls on each other, then set Can Grow to yes. The fields displayed over each other.