Home » Developer & Programmer » Reports & Discoverer » footer in layout in main section (10G)
footer in layout in main section [message #478430] Fri, 08 October 2010 13:38 Go to next message
socotrin
Messages: 3
Registered: October 2010
Junior Member
I have test in the main section of the layout in forms. I want to print the footer on the first page only. If I go to properties and select print object on first page, it still prints the footer in all pages. How can I force the footer on the first page only.

Thanks,

Socotrin
Re: footer in layout in main section [message #478438 is a reply to message #478430] Fri, 08 October 2010 15:38 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
[I don't have Reports installation here to test it myself]

I didn't try, but you might: create a format trigger (for footer objects; the simplest way would be to enclose all of them into a frame, and then create a frame format trigger). In there, check for current page number - you'd use SRW.GET_PAGE_NUM to do that. Return TRUE if you're on the first page, FALSE in any other case. Something like
declare
  l_page_num number;
begin
  srw.get_page_num(l_page_num);
  return (l_page_num = 1);
end;
Previous Topic: Problem While Creating Excel (because of CHR(44))
Next Topic: Bind parameter Defined In report
Goto Forum:
  


Current Time: Fri Mar 29 00:22:14 CDT 2024