Home » Developer & Programmer » Reports & Discoverer » Hide trailer section
Hide trailer section [message #383562] Thu, 29 January 2009 03:14 Go to next message
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
Re: Hide trailer section [message #383563 is a reply to message #383562] Thu, 29 January 2009 03:19 Go to previous messageGo to next message
Littlefoot
Messages: 20897
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');
Re: Hide trailer section [message #383572 is a reply to message #383563] Thu, 29 January 2009 03:32 Go to previous messageGo to next message
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.
Re: Hide trailer section [message #383588 is a reply to message #383572] Thu, 29 January 2009 04:08 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What is M_7's vertical elasticity property set to? Is it Fixed? If so, try to change it to Variable.
Re: Hide trailer section [message #383595 is a reply to message #383588] Thu, 29 January 2009 04:24 Go to previous message
pragatimathur
Messages: 42
Registered: July 2006
Location: DELHI
Member
its variable only...
Previous Topic: Email from reports
Next Topic: Sending date parameter from Reports to Forms 10g
Goto Forum:
  


Current Time: Wed Dec 07 08:46:45 CST 2016

Total time taken to generate the page: 0.07875 seconds