September 15, 2009 at 8:33 am
Hello there,
How will i be able to set the visibility expression of an Textbox to be dependant on the visibilty of a table? what kind of syntax can be used to do this?
The Visibility of the table is dynamic Dependant if there are any results within it.
thinking of something like this as a expression for the text box's visibility property
(but could someone please indicate what the correct syntax might be to do this)
=iif(table1.visibilty = false, false, true)
your help will be greatly appreciated!
Groove is in the heart
September 21, 2009 at 6:41 am
Hi there, if you are trying to hide the entire table if some field on the report is blank, then what you do is
1. Right-Click on the table and go to table properties
2. Go to the visibility tab and select expression located under initial visibility
3. In the expression box type this expression: =IIf(Fields!blah.Value=Nothing,True,False)
This will hide the entire table if field blah is blank.
Hope that helped....if not, please provide some more info so we can further assist you.
October 7, 2009 at 3:06 pm
Did you get a solution to this? To be specific, I would like the text box to only display when there are rows in the table. Thanks
October 8, 2009 at 6:02 am
Is the text box sitting in or outside the table? Does the table currently display anything if no rows exist or are you controlling visibility on that as well?
October 8, 2009 at 8:32 am
I'm using the text box as the title of the table. Therefore, it sits outside the table. I am able to display the table only when there are rows in the table. So when there are no rows in the table, I also dont want to display the title text box.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply