Home Forums SQL Server 2005 Business Intelligence SSAS converts NULL values into string 'NULL' RE: SSAS converts NULL values into string 'NULL'

  • February 5, 2013 at 2:42 am

    #1584237

    Hi,

    I've handled Nulls in SSRS reports coming out of SSAS with this sort of expression.

    =Iif(IsNothing(Fields!ANYFIELD.Value),"The Field Is Null",Fields!ANYFIELD.Value)

    Found here:

    http://www.mredkj.com/vbnet/RSNullCheck.html

    Hope that helps.

    Simon


    MCSE: Data Platform
    MCSE: Business Intelligence
    Follow me on Twitter: @WazzTheBadger
    LinkedIn Profile: Simon Osborne