Home » Developer & Programmer » Reports & Discoverer » Page number in report  () 1 Vote
Page number in report [message #321672] Wed, 21 May 2008 00:31 Go to next message
smithagirish
Messages: 10
Registered: March 2008
Location: kochi
Junior Member
hai all
Can any one pls help me

In my report i have page numbers displayed in the format "Page 1 of 5"..
but if i have only 1 page in the report then i don't want to display "Page 1 of 1" in my report

Thanks
Re: Page number in report [message #323933 is a reply to message #321672] Fri, 30 May 2008 01:37 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Try to right-click that object, then PL/SQL Editor, then write the code, test if total pages is equal > 1, return true otherwise return false. post what you get from it.
Re: Page number in report [message #323983 is a reply to message #321672] Fri, 30 May 2008 03:54 Go to previous messageGo to next message
smithagirish
Messages: 10
Registered: March 2008
Location: kochi
Junior Member
as said by you..
i gave the code
if total pages is equal > 1 then
return true;
else
return false;
end if;

but it is not taking "total pages"
Re: Page number in report [message #324298 is a reply to message #323983] Sun, 01 June 2008 18:26 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

I don't know exactly what you did, you don't post your code. Okay, try this, create a text item, the source must be "totalpages". name that item as 't_pages'. I forgot how to reference an item in report coz i'm not doing it anymore, but your code must be something like this. you put this on item that displays page Of total Page/s.
If t_pages > 1 then
   return(TRUE);
Else
   return(FALSE);
End If;

again, post what you got from here including your code.

[Updated on: Sun, 01 June 2008 18:27]

Report message to a moderator

Re: Page number in report [message #324399 is a reply to message #321672] Mon, 02 June 2008 06:03 Go to previous messageGo to next message
cvs_1984
Messages: 136
Registered: August 2007
Location: Punjab, INDIA
Senior Member

Try It.

You needed is Page no : 1 of 5

Insert the Field and select the property.
They were Choose the : Physical Page Number
Insert another Field and select the property.
They were Choose the : Total Pages



Page no : Physical Page Number (of) Total Pages
Re: Page number in report [message #325040 is a reply to message #324399] Wed, 04 June 2008 21:23 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

have you solved your problem?
Re: Page number in report [message #354778 is a reply to message #321672] Tue, 21 October 2008 03:40 Go to previous message
cvs_1984
Messages: 136
Registered: August 2007
Location: Punjab, INDIA
Senior Member

have you solved your problem?
Previous Topic: Display image
Next Topic: Single quote problem with reports
Goto Forum:
  


Current Time: Wed Nov 27 01:28:42 CST 2024