| how to display alternate pages in a report [message #427045] |
Tue, 20 October 2009 14:32  |
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  |
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
