Home » Developer & Programmer » Reports & Discoverer » Oracle Reports Page Number Problem (Oracle Reports)
Oracle Reports Page Number Problem [message #527235] Mon, 17 October 2011 03:39 Go to next message
buzzyba
Messages: 9
Registered: October 2011
Junior Member
Hi
I am newbie to Oracle Reports
If i insert page number through Insert->Page Number
Its working fine
But my issue is when it exceeds a limit
it does not show page number properly
Eg:From 1000 its showing only 1 digit

Is this the limit for tht option?

If not if i just expand and test for that how can i test without records for 1000 pages
Is there an option for this or i should try with Field Option and setting source as Page Number?

Please help me
Re: Oracle Reports Page Number Problem [message #527242 is a reply to message #527235] Mon, 17 October 2011 04:09 Go to previous messageGo to next message
Littlefoot
Messages: 21547
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Using Reports 10g (by the way, which version do you use?), I just did the same - inserted a page number (Top Right). Report with ~1500 pages displays the number correctly. Also, I don't think that there's such a limit (at least, not the one that should bother you).

Anyway: go to Paper Layout editor, click the "Edit margin" button. Find the "page number" field and try to enlarge it (if that's the culprit).
Re: Oracle Reports Page Number Problem [message #527248 is a reply to message #527242] Mon, 17 October 2011 04:14 Go to previous messageGo to next message
buzzyba
Messages: 9
Registered: October 2011
Junior Member
I Use reports 10g
I tried Expanding the page number field
But i am not sure of testing this
Since i don't have enough data(for >1000 pages) for this to be tested
Re: Oracle Reports Page Number Problem [message #527249 is a reply to message #527248] Mon, 17 October 2011 04:15 Go to previous messageGo to next message
Littlefoot
Messages: 21547
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oh! This query:
select * from all_objects
should produce enough records to fill > 1000 A4 pages. Try it.
Re: Oracle Reports Page Number Problem [message #532771 is a reply to message #527249] Thu, 24 November 2011 09:47 Go to previous message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
Or you can also set the maximum number of records per page to 1 to generate the report output > 1000 pages.
Previous Topic: Report Runtime Error
Next Topic: XLS Report error
Goto Forum:
  


Current Time: Tue Mar 31 05:49:00 CDT 2020