sql server reporting services: Suppress a column in a report -- sql server reporting services

Re: Suppress a column in a report

Chocks
7/24/2006 3:16:50 AM

sql server reporting services: just make the column width to zero. use iif in expression

[quoted text, click to view]

Suppress a column in a report

Renju Mathew
7/24/2006 3:12:17 PM

I want to hide columns in report if that columns having NULL value.Please
reply me if you know the solution.

Thanks,

Re: Suppress a column in a report

toolman
7/26/2006 6:05:17 AM

Renju,
My approach would be to use the Visibility/Hidden property for the
column. Set the Hidden property to an expression. Something like
=IIF(Fields!ColumnDetail.Value = nothing,True,False) should work. Make
sure you're setting the property for the entire column and not just an
individual field or textbox otherwise you'll get undesired white space.
HTH
toolman
[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 in the sql server reporting services group.