Groups | Blog | Home
all groups > sql server reporting services > april 2007 >

sql server reporting services : How to preserve empty space when textbox is hidden


Andrus
4/21/2007 5:40:18 PM
I have 3 textboxes in report:

111111 222222 333333

If second textbox visibility hidden expression evaluates to true,
ReportViewer shows
third textbox immediately after first like

111111 333333

I need that empty space if preserved if textbox is hidden::

111111 333333

How to preserve space without adding other elements to report ?


Andrus.

Tokes
4/22/2007 4:34:35 AM
[quoted text, click to view]

Instead of setting the visibility hidden expression, can you set the
contents of the textbox instead?

E.g. =Iif(hiddenExpression, "", "what I want to display")

?
Andrus
4/23/2007 12:15:47 AM
[quoted text, click to view]

Thank you.
Some my texts are labels, some expressions.
Hidden expressions are complicated.

So it is a lot of work to change labels to expressions, change existing
expressions and remove hidden expressions.

Is'nt there a better solution like specifying absolute left position ?

Andrus.

Tokes
4/23/2007 5:23:52 AM
[quoted text, click to view]

Actually, you could try this:

If you have your textboxes like this:

1111 2222 3333

You could try putting them in rectangles to preserve the positioning?

For example, put 1111 and 3333 in a rectangle (leaving a gap), then
position 2222 in between 1111 and 3333 but not inside the rectangle.

- Tokes
Andrus
4/23/2007 8:19:33 PM
[quoted text, click to view]

I think rectangles make report editing more difficult when there is need
select, move and resize textboxes.

So I will go using your first suggestion by modifying expression to use
Iif()
and convert labels to expressions with Iif()

Andrus.
AddThis Social Bookmark Button