Null values

• Vicki Peters

  SSCommitted

  Points: 1866

  More actions

  February 24, 2009 at 12:31 pm

  #206325

  Hi all,

  I need to create an expression to hide a row in a table if a report value is null; however, I cannot seem to figure out the syntax. I checked the Help file, and all it tells me is to use is Is Emtpy. However, I put that into my expression and I get an error. I have tried:

  =IIf(Is Empty(Fields!ClientID.Value), True, False)

  =IIf(Fields!ClientID.Value Is Empty, True, False)

  =IIf(Fields!ClientID.Value = Is Empty, True, False)

  None of these work. Does anyone know the syntax? And while I'm asking, does anyone know of a good resource for finding out this information? I used to create Crystal Reports and only code in T-SQL. So anytime I need to figure out the syntax of something in SSRS, I get completley stuck. I would love a resource that is NOT the online help file.

  Thanks!

• matzer

  SSCrazy Eights

  Points: 9727

  More actions

  February 25, 2009 at 12:42 am

  #949822

  IsEmpty (without a space) is a MDX function. In SSRS use IsNothing e.g.

  =IIf(IsNothing(Fields!ClientID.Value), True, False)

  Peter