SRW.SET_BEFORE_FORM_HTML
built-in procedureThis procedure inserts any text, graphics, or HTML commands that you want to appear at the top of the HTML Parameter Form. This attribute is useful for placing a logo or some standard links on the Parameter Form .
SRW.SET_BEFORE_FORM_HTML(type,'string');
Parameter |
Description |
|
Is |
|
Is a filename or the text to be inserted, depending on what you specified for the type parameter. |
You can also define this attribute using the Reports Builder user interface:
Property Inspector
|
set the Before Form Type and Before Form Value properties |
The example below sets both the before and after form escapes in the
Before Form trigger. The HTML for the before escape is located in a file
named logo.htm. The HTML for the after report escape is specified within
the PL/SQL itself.
function BeforeForm return boolean is
begin
if ((upper(:MODE) != 'CHARACTER') and
(upper(:DESFORMAT) = 'HTML')) then
SRW.SET_BEFORE_FORM_HTML(SRW.FILE_ESCAPE,'logo.htm');
SRW.SET_AFTER_FORM_HTML(SRW.TEXT_ESCAPE, <B> ||
'<FONT FACE="Arial, Helvetica">' ||
'<FONT COLOR="#FF0000">' ||
'Click <IMG SRC="RUN.GIF" HEIGHT=18 WIDTH=18>' ||
'to run the report using the parameters you have' ||
'specified above. ' ||
'</FONT></FONT></B>');
end if;
return (TRUE);
end;
About the
Reports Builder built-in package (SRW
)
Copyright © 1984, 2005, Oracle. All rights reserved.