Home » Developer & Programmer » Reports & Discoverer » Help me in oracle report developer (win xp)
Help me in oracle report developer [message #440917] Wed, 27 January 2010 22:47 Go to next message
ka_wish
Messages: 87
Registered: October 2007
Location: karachi
Member

dear all friends

any one help me in oracle developer
my requirement is


Exmple Query Here>>>>
____________________


begin

if totalpages = 3 then
srw.set_text_color('black');

end if;
end;
Re: Help me in oracle report developer [message #440919 is a reply to message #440917] Wed, 27 January 2010 22:56 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
You can use the same logic here if you can find the total_number of pages...

http://www.orafaq.com/forum/mv/msg/154418/440816/136607/#msg_440816

Have a look at this.....Translated page for metalink note

Total number of pages


sriram Smile
Re: Help me in oracle report developer [message #440937 is a reply to message #440919] Thu, 28 January 2010 00:10 Go to previous messageGo to next message
ka_wish
Messages: 87
Registered: October 2007
Location: karachi
Member

i am checked all refer link but this query not working properly.
please help Littlefoot how to use total pages filed use in formula function

like
exmple query:

declare
page_num number;
lastpage number;
begin
srw.get_page_num (page_num);
lastpage:=max(page_num);

if page_num = lastpage then
srw.set_text_color('black');
end if;
return(true);
end;
____________________________________________
i think are you understand what i require.

[Updated on: Thu, 28 January 2010 00:11]

Report message to a moderator

Re: Help me in oracle report developer [message #440941 is a reply to message #440937] Thu, 28 January 2010 00:51 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Thats what i said we can do the logic for current page number
But as per the link it not possible to get the last page.You can only print the last page directly...
Thas why i refered some links how to get the last page (see 2,3 links)...If not as you requested Littlefoot he can give you/answer you.

Good luck
sriram Smile
Re: Help me in oracle report developer [message #440953 is a reply to message #440941] Thu, 28 January 2010 01:39 Go to previous messageGo to next message
ka_wish
Messages: 87
Registered: October 2007
Location: karachi
Member

i am try to all logic but result are not found in my requirement
i required usefull query or logic like first use then paste your logic.
Re: Help me in oracle report developer [message #440967 is a reply to message #440953] Thu, 28 January 2010 02:31 Go to previous message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
see how little foot solved the problem here


Hope it will help you...


sriram Smile
Previous Topic: how to make charts in report builder
Next Topic: page number to omit printing on page 1, and print on all pages after
Goto Forum:
  


Current Time: Wed Nov 27 06:25:15 CST 2024