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: 229
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

Report message to a moderator

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: 13959
Registered: September 2008
Location: Rainy Manchester
Senior Member
you could restrict the query by rownum

Report message to a moderator

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: 229
Registered: May 2007
Location: PAKISTAN
Senior Member
Please Guide Me with some Example

thanks

Report message to a moderator

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: 13959
Registered: September 2008
Location: Rainy Manchester
Senior Member
The manuals are wonderful things.

Report message to a moderator

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: 21823
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):

/forum/fa/5979/0/

Report message to a moderator

Previous Topic: Oracle 10g Reports CSV file output issues
Next Topic: sql function
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 30 06:26:08 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.