What is Format Trigger?

To discuss Oracle Forms & Reports related technical issues.
Post Reply
Rammi
Posts: 19
Joined: Fri May 30, 2008 10:40 am
Location: India

What is Format Trigger?

Post by Rammi »

Hi,

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


Regards,
Ram.
annu-agi
Posts: 3
Joined: Wed Mar 05, 2008 9:21 am
Location: Pakistan

Post by annu-agi »

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
rtoogee
Posts: 4
Joined: Thu Jan 15, 2009 11:36 pm
Location: Indonesia

Post by rtoogee »

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
Post Reply

Who is online

Users browsing this forum: No registered users and 5 guests