reporting services - Can I make a text box in SSRS disappear, shrink, or otherwise "roll up" if there's no data? -
i have several text boxes containing calculated data. many of them null or zero. how can save space making them go away unless there's show?
right click on text box , click text box properties
. click visibility
list on left, choose show or hide based on expression
. click fx
button bring expression editor. below example expression hide text box if value null or 0.
=isnothing(sum(fields!test2.value, "dataset1")) or sum(fields!test2.value, "dataset1") = 0
Comments
Post a Comment