Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
CRM On Demand Analytics and Reports
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jun 19, 2011 4:57 PM by
limit records in report to last 5 records
Jun 19, 2011 3:05 AM
i've created a simple report for a custom object, and want to limit the visible records ONLY to the last 5 records in the table.
how can i do that?
This content has been marked as final.
Show 1 reply
Re: limit records in report to last 5 records
Jun 19, 2011 4:57 PM
in response to
What you need to do is create a RANK function on the created date and then filter this by 5. You can see more information on this at
Re: Limit number of records in pivot table