Fields with no data

[varunmathur]

Hi
I wish to hide fields/ reports with null value as the preview with the error message,
Is there a way to just say "NO DATA"
thanks
varunmathur

 

[David R]

Number format fields can be formatted with four properties: <positive format>;<negative format>;<zero format>;<null format>

So 0;-0;;"NO DATA" will do what you're asking, I believe.

Text fields can do something similar with @;"NO DATA"

If you're looking at calculated fields where something in the formula is causing the #Error message, look into IsError().