OraFAQ Forum: Reports & Discoverer » Using page number property in formula

Home » Developer & Programmer » Reports & Discoverer » Using page number property in formula

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

Using page number property in formula [message #240628]

Fri, 25 May 2007 06:30

mrkamran
Messages: 9
Registered: May 2007

Junior Member

Hi,
I want to use "Page Number" and "Total Pages" in my oracle report formula becuse i want to display a message at bottom of my report as Continue on Page 2. When i m currently on page 1 then i want to display Continue Page 2 similarly go on.
Is there any predefined property or function which can give me current page number and total pages in my formula?

Thanks

Report message to a moderator

Re: Using page number property in formula [message #240951 is a reply to message #240628]

Mon, 28 May 2007 00:45

mrkamran
Messages: 9
Registered: May 2007

Junior Member

Is there nobody can give me answer of this simple question???

Report message to a moderator

Re: Using page number property in formula [message #240975 is a reply to message #240951]

Mon, 28 May 2007 02:07

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If it is that simple, how come you don't know the answer?

Fetching the current page number is easy: SRW.GET_PAGE_NUM will do that.

I wouldn't know how to get total number of pages; it may be because of possible circular dependency - value of a page-dependent column (variable) can not be computed until the report is formatted, but the report can not be formated until the format trigger is executed.

However, you might display, for example, "Page 2/13" on the report. It isn't exactly what you'd like to do, but could help. Do that by selecting "Insert - Page Number ..." from the Report Builder's menu.

Just note that displaying total number of pages requires forward referencing which means that you'll have to wait longer for the first page to display as report will have to format ALL pages in order to be able to display the "total number of pages" on every page. For large reports, it surely is a drawback.

Report message to a moderator

Re: Using page number property in formula [message #241385 is a reply to message #240975]

Tue, 29 May 2007 07:36

mrkamran
Messages: 9
Registered: May 2007

Junior Member

I m using
"srw.get_page_nume(pagenum);
package.pagevar := pagenum; "
in format trigger
and store it in package variable and display this variable through formula field as
return (package.pagevar).
But problem is that it display total number of page on all pages whereas i want to display current page number.

Report message to a moderator

Re: Using page number property in formula [message #247772 is a reply to message #240628]

Wed, 27 June 2007 03:05

ramisetti1
Messages: 30
Registered: January 2007

Member

if you want show the page number like 2/15 like

current_page of Total_page
both current_page and Total_page are fields
of is text

Report message to a moderator

Re: Using page number property in formula [message #248020 is a reply to message #247772]

Wed, 27 June 2007 15:46

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Could you, please, post a working PL/SQL code which will use fields you have mentioned in your previous post?

Report message to a moderator

Previous Topic:	Discverer Report Selecting 85M records
Next Topic:	Deleting field

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 18:47:49 CST 2024