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 

enter image description here


Comments