Empty Row In Table

I have a table, single table no grouping. The table can be empty, meaning
will not turn any results due to the condition in the query not being met.
In the report, if the table is empty, I want the row to display something
like "everything's OK".
I was trying to create an Expression for a cell in the table like this:
=IIF(IsNothing(Fields!XXXX.Value), "everything's OK", Fields!XXXX.Value)
This doesn't work. Any suggestions?
Thanks,
JamesLook at this
http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx
under the 10. Layout - Do you show errors in Red?
This talks about using the 'NoRows' property of the report table, also
about using a textbox and tweaking its visibility.
Sambhaji|||Maybe:
=IIF(Fields!XXXX.Value="", "everything's OK", Fields!XXXX.Value)
"James" <James@.discussions.microsoft.com> escribió en el mensaje
news:5B35F476-5894-400D-A3A3-56FAC0F0BC2E@.microsoft.com...
>I have a table, single table no grouping. The table can be empty, meaning
> will not turn any results due to the condition in the query not being met.
> In the report, if the table is empty, I want the row to display something
> like "everything's OK".
> I was trying to create an Expression for a cell in the table like this:
> =IIF(IsNothing(Fields!XXXX.Value), "everything's OK", Fields!XXXX.Value)
> This doesn't work. Any suggestions?
> Thanks,
> James