Make row in table shrink or collaps

How can I make a row in a table shrink or collapse when there's no data for
that row? I have a table with several detail rows in it. the bottom row
has 2 cells. the first one if for a label and the second one is for the
data.
cell 1: =iif(len((Fields!Id_Assignee.Value))>0,"Assignees","")
cell 2: =(Fields!Id_Assignee.Value)
The iff statement in cell 1 works good so when there's no data it doesn't
show the label. Now when there's no data in cell 2, how can I make this row
go away completely? I set the CanShrink property for both cells to true.
Thanks.
--
moondaddy@.nospam.nospamPut the hight of the row = 0 (you have to do this in the properties panel,
not in the window you get by right clicking) and enable the hight to grow
"moondaddy" wrote:
> How can I make a row in a table shrink or collapse when there's no data for
> that row? I have a table with several detail rows in it. the bottom row
> has 2 cells. the first one if for a label and the second one is for the
> data.
> cell 1: =iif(len((Fields!Id_Assignee.Value))>0,"Assignees","")
> cell 2: =(Fields!Id_Assignee.Value)
> The iff statement in cell 1 works good so when there's no data it doesn't
> show the label. Now when there's no data in cell 2, how can I make this row
> go away completely? I set the CanShrink property for both cells to true.
> Thanks.
> --
> moondaddy@.nospam.nospam
>
>|||Thanks that is exactly what I was looking for.
Does this mean Can Shrink doesn't really work?
Dave
"Antoon" wrote:
> Put the hight of the row = 0 (you have to do this in the properties panel,
> not in the window you get by right clicking) and enable the hight to grow
> "moondaddy" wrote:
> > How can I make a row in a table shrink or collapse when there's no data for
> > that row? I have a table with several detail rows in it. the bottom row
> > has 2 cells. the first one if for a label and the second one is for the
> > data.
> >
> > cell 1: =iif(len((Fields!Id_Assignee.Value))>0,"Assignees","")
> > cell 2: =(Fields!Id_Assignee.Value)
> >
> > The iff statement in cell 1 works good so when there's no data it doesn't
> > show the label. Now when there's no data in cell 2, how can I make this row
> > go away completely? I set the CanShrink property for both cells to true.
> >
> > Thanks.
> >
> > --
> > moondaddy@.nospam.nospam
> >
> >
> >