There is also a nvl() function, nvl(.null., '') will return an empty string. Also, you can set nulldisplay to ~ or something.
>It can be done in two places. First, you can get rid of NULLS in view. In SELECT part of the view you can use IIF(!ISNULL(fieldname), fieldname, "") AS fieldname. You wont have any NULLS in view then. Second, in report itself. If you dblclick on a field you will see 'Print when'. Say !ISNULL(fieldname).
>HTH Mark
--Todd Sherman
-Wake Up! Smell the Coffee!