OraFAQ Forum: Reports & Discoverer » How to restrict record fetching in reports

Home » Developer & Programmer » Reports & Discoverer » How to restrict record fetching in reports

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to restrict record fetching in reports [message #110345]

Sun, 06 March 2005 05:31

rravindhran
Messages: 7
Registered: March 2005
Location: India

Junior Member

Hi:

I have to restrict records displayed in the reports say to 3. I cannot do it in the SQL query. How to acheive the same in the Oracle Reports. Do I need to use Format Trigger if so how to do it.

Thanks in advance,
Ravi.

Report message to a moderator

Re: How to restrict record fetching in reports [message #110377 is a reply to message #110345]

Mon, 07 March 2005 03:03

Maaher
Messages: 7065
Registered: December 2001

Senior Member

SELECT *
FROM ( _your_query_ )
WHERE rownum < 4

this limits the output to 3 rows.

MHE

Report message to a moderator

Re: How to restrict record fetching in reports [message #111368 is a reply to message #110345]

Tue, 15 March 2005 16:59

Kalpana Srinivas
Messages: 10
Registered: January 2004

Junior Member

hi

in query's properties you have an option "maximum rows to fetch".
set the value for this property. Report Builder will only retrieve the number of rows for the query that you specify in this property.

let me know if it meets your req.

Report message to a moderator

Re: How to restrict record fetching in reports [message #111402 is a reply to message #111368]

Wed, 16 March 2005 03:13

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Or use the 'maximum records per page' property of the repeating frame.

MHE

Report message to a moderator

Previous Topic:	Rotate
Next Topic:	URL from Discoverer Sheet Column on Portal?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 18:37:25 CST 2024