I am new to crystal reports so plz help me.

I want the previewed report to omit fields from the database based on what their value is.

For example, if we have a mailing list: The address is made from three seperate fields. If any of the fields are a certain value, like "NULL" (A string) then I don't want NULL to appear in the previewed report. It would be better if these values were filtered out in some way without sacrificing the way the mailing list address is formatted.

Ideas?

Thank you in advance.

++Roddy