displaying 0's instead of blank cells , in a report?

Anyone know a way of doing this?
Basically in cells where there is no results, I get blanks and I think 0's
would be a lot nicer.=iif(Fields!Fieldname.Value is nothing, 0, Fields!Fieldname.Value)
or you can return the 0 in your data source query. For example if using SQL
Server,
select isnull(Columnname,0) AS MyColumn, ... FROM Mytable
HTH
Charles Kangai, MCT, MCDBA
"Matt Swift" wrote:
> Anyone know a way of doing this?
> Basically in cells where there is no results, I get blanks and I think 0's
> would be a lot nicer.
>
>