Home Forums SQL Server 2005 Business Intelligence SSAS converts NULL values into string 'NULL' RE: SSAS converts NULL values into string 'NULL'
s_osborne2
SSCertifiable
Points: 6726
More actions
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