Home » Developer & Programmer » Reports & Discoverer » How to Restrict Number of Rows in Reports 6i (Reports 6i)
How to Restrict Number of Rows in Reports 6i [message #395465] Wed, 01 April 2009 09:14 Go to next message
qanita786
Messages: 213
Registered: May 2007
Location: PAKISTAN
Senior Member
How to Restrict Number of Rows in Reports 6i for example i want that maximum 10 rows displayed on a single match

kind regards
Re: How to Restrict Number of Rows in Reports 6i [message #395466 is a reply to message #395465] Wed, 01 April 2009 09:15 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
you could restrict the query by rownum
Re: How to Restrict Number of Rows in Reports 6i [message #395477 is a reply to message #395465] Wed, 01 April 2009 10:31 Go to previous messageGo to next message
qanita786
Messages: 213
Registered: May 2007
Location: PAKISTAN
Senior Member
Please Guide Me with some Example

thanks
Re: How to Restrict Number of Rows in Reports 6i [message #395480 is a reply to message #395465] Wed, 01 April 2009 10:42 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
The manuals are wonderful things.
Re: How to Restrict Number of Rows in Reports 6i [message #395498 is a reply to message #395465] Wed, 01 April 2009 12:03 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't have Reports 6i to check, but I guess it won't cost much if you try it: as we are speaking Reports here, perhaps you'd be interested in setting the "Maximum rows to fetch" query property to some value (10 in your case):

./fa/5979/0/
Previous Topic: Oracle 10g Reports CSV file output issues
Next Topic: sql function
Goto Forum:
  


Current Time: Sun Dec 04 00:25:59 CST 2016

Total time taken to generate the page: 0.10276 seconds