sql server reporting services: Is there a way to access a textbox's properties with similar syntax below:

=ReportItems!textbox22.visibility.hidden = true

I noticed only value was available for the ReportIems Global Var, I was
wondering if something else was available.
I need to check the visibility of a textbox to set a value of another textbox.

Thanks,
Don

[quoted text, click to view]

Hi Don,

You can use IIf function to implement this.
For example:

=IIf(ReportItems!textbox22.visibility.hidden, true, false)

btw: I am no exactly sure that visibility.hidden actually exists. Wasn't it
..Hidden? Sorry can not check it in the moment.

HTH,

--
Martin Kulov
http://www.codeattest.com/blogs/martin

MCAD Charter Member
MCSD.NET Early Achiever
MCSD

I'm trying to do the same thing here.

I'm using
=IIf(ReportItems!Textbox24.visibility.hidden, "", Sum(Fields!AbRate.Value))

But I get an error:
The value expression for the textbox ‘textbox9’ refers to the report item
‘Textbox24’. Report item expressions can only refer to other report items
within the same grouping scope or a containing grouping scope.

Textbox9 is where the iif is. Textbox24 is in another row, but in the same
group as Textbox9. (Textbox9 is in the group header row - Textbox24 is in
the group footer row)

Any ideas how to fix it?

[quoted text, click to view]