CODEWITHSUNDEEP
reporting-servicesssrs-2008
GoldAnchor
GoldAnchor

Reputation: 129

SSRS hide white space from empty textbox outside of tablix

I'm new to both SSRS and development in general, and can't seem to find the answer to my problem. The report itself is simple-- a stored procedure collects responses and I display them using Lookup expressions in textboxes. Some fields are not required, so some of the textboxes are empty in my report. I would like to remove the white space left by the empty textbox.

In retrospect, I wish I had used a table to format the page, but since I have a very large number textboxes with expressions, I can't easily refactor my work. I found solutions for tablixes (Trying to Get Rid of White Space in SSRS Report), but nothing for free-standing text boxes.

Is this possible?

Upvotes: 0

Views: 3895

Answers (1)

Pops
Pops

Reputation: 498

If you right click on the textbox and navigate to 'Textbox Properties...' you can toggle the visibility of the textbox, and if it is hidden you wont see the white box. You could also enter expressions, like the one below for example will hide the textbox if there is no data in it.

=iif(isnothing(reportitems!Textbox1.Value),false,true)

Upvotes: 1

Related Questions