ERPstuff - Oracle EBS Community

Hi,

What is the Format Trigger? Where it can be useful..[?]


Regards,
Ram.

Format triggers are in report developer and it is use for format output dependent on data for e.g. if i want to show figure if it is positive in blue color font and if it is negative in red in color then i have to use format triggre.



[quote]Hi,

What is the Format Trigger? Where it can be useful..[?]


Regards,
Ram.

<i><div align="right">Originally posted by Rammi

Or you can use it for visible or non visble frame,field etc with the exceptional condition..

Example:

function F_NM_BRG4FormatTrigger return boolean is
begin
if :ITEM_DESC4 IS NULL THEN
RETURN(FALSE);
ELSE
return (TRUE);
END IF;
end;

The function will hide the field if ITEM_DESC4 is null. And display the field if ITEM_DESC4 have a value