 |
|
Oracle Tips by Burleson |
Report
Pagination
Report
Pagination is the control of which series of rows are being displayed
to the user based on the entire set of data in the report.
The goal of this section is to give an
understanding of what is pagination, how to setup pagination in
reports, and how it is reset. The reason it would need to be reset is
so any subsequent searches would not leave the user in an undesirable
place in regards to the pagination. For example, select the
pagination to view rows 31 – 45. Then change the search page item and
return a different result set. If the pagination were not reset, we
would automatically be taken to rows 31 – 45 of the new result set.
This is not the desired result. So, the pagination should be reset
any time a new search is submitted.
The easiest way to explain resetting pagination is
with the use of Figure 7.5. The figure shows a user looking at the
pagination of rows 31 – 45. A reset of the pagination would return
the user back to the beginning to rows 1 – 15.
Resetting the pagination is done by creating a
Page Process. There is a wizard that makes this step very easy.
1.
Navigate to the page definition page and click on the  icon
in the Processes section under the Page Processing region.
2.
On the Process Type page: choose the Reset Pagination option
and click Next.
3.
On the Create Page Process page, leave everything at the
default value except the following
This setting is
case sensitive and must be typed as shown. This step is setting up
the process to only process when the Go button is pressed or when the
user is in the P11_REPORT_SEARCH page item and presses the Enter key.
Under these two conditions, the Reset Pagination process will be
processed. Any other time the page is submitted and rendered again,
this process will be ignored. This performs an If … Then logic
statement.
Whenever the page is resubmitted with new search
criteria, the report will automatically be returned to the first set
of rows in the result set.
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
