Home » Developer & Programmer » Reports & Discoverer » Repeating frame parameter (Oracle Reports 6.0)
Repeating frame parameter [message #447002] Thu, 11 March 2010 07:50 Go to next message
Messages: 1
Registered: March 2010
Junior Member

I would like to know is it possible to make number of rows per page in report repeat frame propertie as variable or parameter?
I would like to have different number od rows per page depending on input parameter when report is run.

Re: Repeating frame parameter [message #448372 is a reply to message #447002] Tue, 23 March 2010 01:11 Go to previous message
Messages: 20850
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't think so.

What you might do is to restrict number of fetched records. To do that, you'd either use SRW.SET_MAXROW built-in or create your own lexical parameter which would, as a result have something like
... WHERE ROWNUM < :parameter_value
Previous Topic: Bullet Point
Next Topic: alternate of a button in oracle 10g reports
Goto Forum:

Current Time: Sun Oct 23 05:29:36 CDT 2016

Total time taken to generate the page: 0.11277 seconds