Home » Developer & Programmer » Reports & Discoverer » Dynamically set max number of records per page (Oracle reports 10g)
Dynamically set max number of records per page [message #630637] Thu, 01 January 2015 08:56 Go to next message
nilanjanpal
Messages: 8
Registered: May 2014
Location: Kolkata
Junior Member
I am trying to set the max number of records fetched in a page dynamically. When I do that in the property inspector it works but it's static and I need it to change it dynamically.

If anybody can help, it would be great.
Re: Dynamically set max number of records per page [message #630640 is a reply to message #630637] Thu, 01 January 2015 09:51 Go to previous messageGo to next message
Littlefoot
Messages: 21592
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't have Reports here so I can't try it myself, but - open Reports Online Help system, search for the SRW built-in package and review its procedures. I presume that, if it is possible to do it dynamically, one of SRW's procedures would do it.

If not, no idea, sorry.
Re: Dynamically set max number of records per page [message #631202 is a reply to message #630640] Sat, 10 January 2015 05:41 Go to previous message
shahzad-ul-hasan
Messages: 561
Registered: August 2002
Senior Member
Solution No 1:
Put some dummy object, like empty frame, after each lot group, set the object's "New page after" property to Yes, and suppress the object conditionally if users do not want lots separated.

Solution No 2:
1. Set page break after / before of any object in the report.
2. Set a Maximum Records per page of repeating frame (if it is required to put a page break for each group).

[Updated on: Sat, 10 January 2015 05:45]

Report message to a moderator

Previous Topic: Reports migration 10 to 11g - style sheets formatting and pagination issues
Next Topic: Print BARCODE from EBSR12 to Zeebra TLP 2844
Goto Forum:
  


Current Time: Sun Sep 20 19:55:57 CDT 2020