August 27, 2007 at 8:48 am
Hi-
I have a basic report with one group and 2 detail lines. The second line was added to display LONG text like a person's "Title". My probelm is, if the person doesn't have a title, I want to make the row invisible - make its height zero, toggle its visibility, make is "shrink" - whatever way works.
Unfortunately I've made the "CanShrink" proprty True but the row still appears even though there is no "Title" for a person. How can I hide this detail row if there is no data ?
Thanks - B
August 27, 2007 at 9:47 am
Ok Finally....
There is no visible "Expression" editor for the "Hidden" attribute of the parent "Visibility" attribute for a table row - BUT - you can edit one anyway...
So, I set the tablerow visibility property based on the "is nothing" proprty of my textbox in question and voila - it works...
So, this is in the "Hidden" part of the properties...
=iif(Fields!MySometimesEmptyField.Value Is Nothing, true, false)
HTH someone - B
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply