How can I suppress empty fields in Oracle9i report 1

[mutinda1967]

How can I suppress empty fields in a report so that they don't appear as empty space. For instance I created a report and address Line 2 appears as an empty space. How can I suppress address Line so that it only appears when it is available? Thanks

 

[lava1178]

Hi ,
You can try writing a format trigger where you check if the address Line2 is NULL. Return False when NULL else return true.


Hope this helps

 

[bandarna]

You should write a formula column on repeating frame if it is only single column. Address line fields are mostly single line fields.

If that is not a address line field and one of the column in a log report, don’t include that column in the report, instead create one formula column and write a formula trigger.

IF :column IS NOT NULL THEN
RETURN (TRUE)
ELSE RETURN(FALSE);
END IF;

 

[bandarna]

SORRY AT LAST LINE format trigger not formula trigger.