OraFAQ Forum: Reports & Discoverer » Hide trailer section

Home » Developer & Programmer » Reports & Discoverer » Hide trailer section

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Hide trailer section [message #383562]

Thu, 29 January 2009 03:14

pragatimathur
Messages: 42
Registered: July 2006
Location: DELHI

Member

Hi all,

I have 2 reports,
one in main section and another in trailer section.
This works fine.

But it depends upon the criteria of front end that trailer section report should be shown or not.
if suppose :p_audit='Y' THEN
trailer section report should be displayed.
else
only main section report to be dispalyed.

my question is how to hide trailer section else it will show blank page.

Any suggestions would be helpful!! Thanks for the help

Report message to a moderator

Re: Hide trailer section [message #383563 is a reply to message #383562]

Thu, 29 January 2009 03:19

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Create a Format Trigger for the outmost frame in the trailer section which would return TRUE ("display it") or FALSE ("hide it"), depending on the "p_audit" parameter value. Something like

return (:p_audit = 'Y');

Report message to a moderator

Re: Hide trailer section [message #383572 is a reply to message #383563]

Thu, 29 January 2009 03:32

pragatimathur
Messages: 42
Registered: July 2006
Location: DELHI

Member

i did this in last frame i.e. main frame

function M_7FormatTrigger return boolean is
begin
if :p_audit='Y' THEN
return (TRUE);
ELSE
RETURN FALSE;
END IF;
end;

but then also blank page is coming for trailer section.

Report message to a moderator