NULL displays in report

I have a reports that basically prints the contents of a table so the users
can export the dat to excel. In the areas where there is a NULL value in the
table, the word NULL shows up on the report and when it is exported to Excel.
Is there an easy way to change this so that the values show up as empty?Okay, so you're probably confused as to why this post is here. It was
because I was confused as to why the NULL would actually appear in the report
since I never had that problem before and Null values should appear blank in
the fields. I tried writing an expression IIF(Field!mydata.value = Nothing,
"", Field!mydata.value) and it didn't work. Then I got the crazy notion that
just maybe some enter the word 'NULL' as text into that field. Preposterous,
you say? Well, you're wrong. Someone actually went in and updated all the
empty values with the the text NULL.
Perhaps someone was bored or playing a joke... Maybe.
Perhaps someone is actually that stupid... Likely.
Perhaps someone is trying to make my head explode on a Friday afternoon...
Definitely.
"Andy" wrote:
> I have a reports that basically prints the contents of a table so the users
> can export the dat to excel. In the areas where there is a NULL value in the
> table, the word NULL shows up on the report and when it is exported to Excel.
> Is there an easy way to change this so that the values show up as empty?