OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Total Page Number (Oracle Report 6i)

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

Total Page Number [message #404214]

Wed, 20 May 2009 22:23

shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune

Senior Member

Hello all,
Can anybody tell me, How can I get Total Number Pages in report?
I have used srw.get_page_num in format trigger.
But for that function User must have to go last page. So I want to know last page number without going to last page.
Plese Help me
Thanks

Report message to a moderator

Re: Total Page Number [message #404220 is a reply to message #404214]

Thu, 21 May 2009 00:04

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

Senior Member
Account Moderator

As far as I know, you can't do that unless you reach the last page. It means that report doesn't know total number of pages until it is completely formatted which, actually, means that it must get to its last page.

I've seen quite a few questions like yours but no satisfactory answer so far. Sorry.

Report message to a moderator

Re: Total Page Number [message #404230 is a reply to message #404214]

Thu, 21 May 2009 01:04

hisham99
Messages: 106
Registered: October 2008
Location: united arab emirates

Senior Member

go to your layout report
1- create field
2-open property of that field and change the source to(total pages)
3-run your report it will show you the total number of that report on the first page

Report message to a moderator

Re: Total Page Number [message #404239 is a reply to message #404230]

Thu, 21 May 2009 01:47

shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune

Senior Member

Thanks for all ..
Can I get that Value of field which is added on layout for Total pages.
So that I can Store in table.

Report message to a moderator

Re: Total Page Number [message #404254 is a reply to message #404230]

Thu, 21 May 2009 02:25

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

Senior Member
Account Moderator

Hisham99,

your suggestion works fine - as far as displaying a total number of pages is concerned. You don't even have to create a field - it can be done by specifying it using the ampersand (&) character in the Paper Layout Editor as

&totalpages

However, the problem is how to find that number in Data Model layout ... people would usually want to perform certain calculations based on "total number of pages", such as storing it into a table (as @shekhar.salunkhe would like to) or

if current_page_number = total_number_of_pages then
   do_something;
end if;

Do you know how to do that?

Report message to a moderator

Re: Total Page Number [message #404285 is a reply to message #404254]

Thu, 21 May 2009 04:41

shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune

Senior Member

Yes Sir,
Actually I want that total number of pages store into a table.
And by using that number, I have to calculate charges per page but without going to last page of report. (I mean User need not go to last page)

Please Help me...

Report message to a moderator

Re: Total Page Number [message #404700 is a reply to message #404285]

Fri, 22 May 2009 21:54

shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune

Senior Member

Any New Suggestion?

Report message to a moderator

Re: Total Page Number [message #404814 is a reply to message #404214]

Sun, 24 May 2009 08:13

hisham99
Messages: 106
Registered: October 2008
Location: united arab emirates

Senior Member

i try this report and its work fine
first you have to create this table using (scott/tiger)
create table code
(page_num number(6));

Attachment: page_num.rdf
(Size: 84.00KB, Downloaded 1637 times)

Report message to a moderator

Re: Total Page Number [message #404816 is a reply to message #404214]

Sun, 24 May 2009 08:33

hisham99
Messages: 106
Registered: October 2008
Location: united arab emirates

Senior Member

sorry ! please use this attachment

Attachment: page_num.rdf
(Size: 92.00KB, Downloaded 1729 times)

Report message to a moderator

Re: Total Page Number [message #404842 is a reply to message #404214]

Sun, 24 May 2009 23:13

hisham99
Messages: 106
Registered: October 2008
Location: united arab emirates

Senior Member

if you want to store only the last page number then
make some change in insert_page procedure as below

PROCEDURE insert_pages( p_page in number) is

begin
update scott.code
set page_num =p_page;

if sql%rowcount=0 then
insert into scott.code(page_num)
values
(p_page);
end if;
commit;
end;

Report message to a moderator

Re: Total Page Number [message #405147 is a reply to message #404814]

Tue, 26 May 2009 09:59

shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune

Senior Member

Thanks a lot,
Problem is solved

Report message to a moderator

Previous Topic:	Inventory Valuation with Fifo and Lifo
Next Topic:	Excel output from Oracle Reports 3.0

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 03:54:22 CST 2024