Another trick is to make a flag for each row to test your formula. Add the formula field to the detail row to see / use it for testing. Start adding () around each of the NULL or "" per field if you use them (or use Lockwelles all isnull's first suggestion).
Start with one condition then add another until you see it "break".
if isnull({CUSTOMER.CUSTOMER_XREF_CODE}) or {CUSTOMER.CUSTOMER_XREF_CODE}="" then 'Suppress' else 'Show'
Did this give the correct flag?
Now add another one to test....
if
(isnull({CUSTOMER.CUSTOMER_XREF_CODE}) or {CUSTOMER.CUSTOMER_XREF_CODE}="")
or
(ISNULL({CUSTOMER.fname}) or {CUSTOMER.fname}="")
then 'Suppress' else 'Show'
Keep going unitl you see what field breaks the expected ('corect') value
Edited by DBlank - 21 Oct 2009 at 9:50am