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)

Repeat report item with data region on every page

Does this functionality work?
I've tried textboxes, rectangles...nothing seems to "repeat" when my data
region (table) object spans multiple pages.
Advise'
Thx,
RussellTry using a list... I had the same problem... In the properties find Dataset
Name, select your data set, set PageBrakeAtEnd = True
"Russell Hardie" wrote:
> Does this functionality work?
> I've tried textboxes, rectangles...nothing seems to "repeat" when my data
> region (table) object spans multiple pages.
> Advise'
> Thx,
> Russell
>
>