Groups | Blog | Home
all groups > sql server reporting services > july 2005 >

sql server reporting services : Collapse/hide a cell


JeffreyWowk
7/21/2005 12:59:07 PM
How would I go about collapsing a table cell if its contents are NULL.

I have two cols. Left side holds number and the right side holds legal stuff
(LongText). When the left side is NULL then the right side is going to be a
title for a new section, and I would like it to be positioned more to the
left and not aligned with the right col. And I'd like to do this without
screwing around with my SQL table
Ben Sullins
7/21/2005 2:28:03 PM
You should be able to enter a formula in the two visibilty property boxes of
the cell. It would look something like this:

iif(Fields!myField.Value="",True,False) <- for the Visibilty Property
iif(Fields!myField.Value="",myToggleItem,"") <- for the Toggle Item Propery

Hope this helps..
--
Ben Sullins
www.kingofthegreens.com

[quoted text, click to view]
Tokklas
7/22/2005 7:52:04 AM
I find that using 'is nothing' works in most cases:
iif(Fields!myField.Value= is nothing,True,False)
--
U. Tokklas


[quoted text, click to view]
AddThis Social Bookmark Button