Getting rid of 0 and 'NaN' values in my report?

Hello,

I have a report produced by RS 2005. And I am wondering if there is a way to not display values that are '0' or 'NaN'. It also applies to calculated fields which are displayed as percentages and I don't want to have '0%' or 'NaN' for those columns as well. Any help is greatly appraciated.

Thanks

Quick and dirty fix is to write the expression.

Select the required report item (text box)

Choose expression for property <Value>

=iif(Fields!FieldName.Value=0,"",Fields!FieldName.Value)

|||Thanks for the answer.