Search code examples
reporting-servicesexpressionssrs-2012sqldatatypes

SSRS Expression for hiding the row when a column value = 0

I'm attempting to hide a row based on a column having the value 0. The Quantity column is a decimal datatype.

I'm trying =IIf(Fields!Quantity.Value = 0 True,False) in row visibility

My error is:

error: [BC30455] Argument not specified for parameter 'TruePart' of 'Public Function IIf(Expression As Boolean, TruePart As Object, FalsePart As Object) As Object'.

class   |  Quantity | AcctV | ExtVal |
GENERAL |    20     |  49   |  980   |
RETAIL  |    0      |   0   |  0     |   <-- This should be invisible
Solution

  • You are missing a comma after the zero

    =IIf(Fields!Quantity.Value = 0, True,False)

    Actually you can simplify the whole thing and just use

    =Fields!Quantity.Value = 0

    as this will return true or false anyway. No need for IIF