Post reply

Replacing NULL in Reporting Services

  • July 11, 2008 at 10:31 am

    #188071

    I have a field where I'm trying to replace it's value of 0 to "-" or if the field is empty to "-".

    The data is coming from Analysis Services and this particular field shows (null) under the Data tab. The issue is the field is missing, so I can use the IsMissing property but since I'm also testing for 0 I'm running into a problem. I get the error "This field is missing from the returned result set from the data source."

    I tried to write the expression as

    =iif(Fields!Stat_Qty.IsMissing, "-", iif(Fields!Stat_Qty.Value = 0, "-", Fields!Stat_Qty.Value))

    To test if the member is empty first then if false test if the value is 0. This doesn't work though.

    Any suggestions?

    Thanks

  • July 14, 2008 at 4:04 am

    #842272

    Try the following expression:

    =iif(Fields!Stat_Qty.Value = nothing, "-", iif(Fields!Stat_Qty.Value = 0, "-", Fields!Stat_Qty.Value))

  • June 23, 2010 at 9:04 am

    #1184012

    Thanks, that helped me today 🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply