Home » Developer & Programmer » Reports & Discoverer » how to display alternate pages in a report (report)
how to display alternate pages in a report [message #427045] Tue, 20 October 2009 14:32 Go to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
For example my report contains 10 pages,
i want to display either even numbered pages like 2,4,6,8
or odd numbered pages 1,3,5,7,9.
I think it is possible through between pages trigger.
i tried it but not able to get the output.
if any one knows please reply me.

regars
siva
Re: how to display alternate pages in a report [message #428335 is a reply to message #427045] Tue, 27 October 2009 23:57 Go to previous messageGo to next message
p.kumar.apps.dump
Messages: 1
Registered: October 2009
Location: chennai
Junior Member
Hi Shiva,

Inorder to get the even number of pages in oracle report builder
use the following script at the format trigger of the MAIN FRAME.so you will get the even or odd number of pages.

1)For odd number of pages

function M_1FormatTrigger return boolean is
f_pagno number;
begin
srw.get_page_num (f_pagno);
If MOD(f_pagno,2)=1 then
return (TRUE);
Else
return (FALSE);
End if;
return (TRUE);
end;

2)For even number of pages

function M_1FormatTrigger return boolean is
f_pagno number;
begin
srw.get_page_num (f_pagno);
If MOD(f_pagno,2)=0 then
return (TRUE);
Else
return (FALSE);
End if;
return (TRUE);
end;

Regards,
Prem.
Re: how to display alternate pages in a report [message #428529 is a reply to message #428335] Wed, 28 October 2009 12:16 Go to previous message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
Thank you very much Mr.p.kumar
i got the required output.
Previous Topic: how to display output of the report in tabular format
Next Topic: Reports 10g
Goto Forum:
  


Current Time: Tue Sep 27 07:42:08 CDT 2016

Total time taken to generate the page: 0.07478 seconds