OraFAQ Forum: Reports & Discoverer » Print only odd page numbers in the report

Home » Developer & Programmer » Reports & Discoverer » Print only odd page numbers in the report

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

Print only odd page numbers in the report [message #155937]

Thu, 19 January 2006 14:44

jayasree
Messages: 5
Registered: December 2005
Location: Hyderabad

Junior Member

Hi All,

Can somebody guide me on how to print only odd page numbers in reports 6i/9i.

Awaiting your valuable inputs.

Thanks n Kind Regards,

Jayasree.

Report message to a moderator

Re: Print only odd page numbers in the report [message #164091 is a reply to message #155937]

Tue, 21 March 2006 16:04

spinky
Messages: 21
Registered: March 2006

Junior Member

Hi jayashree,

Just saw ur posting..
Use SRW.GET_PAGE_NUM(PAGE_NUM);(declare page_num as number)
in your format trigger..
Write the following code:

PAGE_NUM NUMBER;
L_ODD_EVEN NUMBER;
begin
SRW.GET_PAGE_NUM(PAGE_NUM);
SELECT MOD(PAGE_NUM,2) INTO L_ODD_EVEN FROM DUAL;
IF L_ODD_EVEN=1 THEN
return (TRUE);
ELSE
RETURN(FALSE);
END IF;
end;

Report message to a moderator

Previous Topic:	Query regarding Parameters
Next Topic:	Books for oracle report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 30 14:05:49 CDT 2024