Hiding Table Rows

Posted by David Stein on Stack Overflow See other posts from Stack Overflow or by David Stein
Published on 2010-05-14T13:15:16Z Indexed on 2010/05/15 6:54 UTC
Read the original article Hit count: 407

Filed under:
|
|

I have a table that I'm using to show details from the line items of a quote. I want to hide a particular row depending on the value of the field in it. The expression I've tried is to set the row visibility to:

=IIF(isnothing(First(Fields!NEW_PRICEBREAKS.Value, "QuoteDetail")),true,false)

When I run the query from the dataset "Null" returns for NEW_PRICEBREAKS for most of the records.

Also, when I expanded the row with another column with this expression:

=IIF(isnothing(First(Fields!NEW_PRICEBREAKS.Value, "QuoteDetail")),"is nothing","not nothing")

I see "not nothing" repeated over and over again. I've attempted to use TRIM inside of the isnothing to remove spaces and it still doesn't work.

Also, the sql data type for NEW_PRICEBREAKS is nvarchar(MAX).

Any ideas how I can suppress this row correctly?

© Stack Overflow or respective owner

Related posts about ssrs

Related posts about ssrs-2008