Friday, March 23, 2012

replace Null with Zero"0"

I have a colunm name (Countystcd) in a matrix, and i have used the mentioned colunm in Data Region of Matrix which shows thw sum of count for each state, i want to replace null with 0 in report please help me in this regard.

thanks
regards
Mohammad Yaseen

Use IsNothing function to check for null and if true display 0.

IIf(IsNothing(Fields!Countysctd.Value), 0, Fields!Countysctd.Value)

Shyam

|||it is not working|||don't forget =|||=IIf(Fields!Countysctd.Value IS NOTHING, 0, Fields!Countysctd.Value)

No comments:

Post a Comment