Hi,
What is the Format Trigger? Where it can be useful..[?]
Regards,
Ram.
What is Format Trigger?
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
[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
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
Who is online
Users browsing this forum: No registered users and 7 guests