Make row in table shrink or collaps -- sql server reporting services

moondaddy
5/26/2005 5:16:38 PM

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

Antoon
5/26/2005 11:21:01 PM

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

[quoted text, click to view]

Dlloyd
6/27/2005 6:38:05 AM

Thanks that is exactly what I was looking for.

Does this mean Can Shrink doesn't really work?

Dave

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Make row in table shrink or collaps