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

sql server reporting services : Toggle visibility


Alien2_51
5/4/2007 5:29:03 PM
I have a text box that I'd like to toggle visibility on when a report
parameter is null or an empty string... How do I do that...?

Thanks!

EMartinez
5/4/2007 6:28:36 PM
[quoted text, click to view]


You will want to right-click the textbox control -> select Properties -
[quoted text, click to view]
of Expression and enter something like the following:
=iif(Len(Parameters!ParameterName.Value) > 0 and Parameters!
ParameterName.Value <> Nothing, True, False)

Regards,

Enrique Martinez
Sr. Software Consultant
AddThis Social Bookmark Button